Formulas (Count and Sum in same Expression)

[mjtowne]

 Hi,

I am trying to understand how to combine a sum(Field A) / Count(FIeld B) as Output

I can see that you cant sum and count in the group by on individual fields but how do you use two fields to form a new  one as the formula section doesnt support count and sum?

Thanks

Martin

[s_pichaipillai · Accepted solution]

 Use summarize tool and aggregate your data SUM , Count then use formula tool to do your calculation