this is my understanding:
sum is used for int fields to add up
count is used to count the the records, not the sum of the content of the field.
so why is sum different than count for a choice field?
if anything i would expect sum to be higher than count because sum is maybe adding the number of characters or something.
Hi @juan9 ,
Count: is Pretty simple group by : Cout of each gropup by element
Sum : Value of the field selected for sum for each record *grouped by number
Example:
1)In your report "111" , its stright group by on the type , number of string type field across all the table is 47,283
2)In your "22222", for the same : Open these records in a separate tab, group by choice field , you wi;ll see something like this
now , go and get choice values for each of these types i.e
now calculate i,e
12577*0 +311858*0 +4204*1+722*2+2505*3+5*4=13,183 which is less than count
Report(in my PDI) : Count
Sum:
Hope this helps!!
Hi @juan9 ,
Count: is Pretty simple group by : Cout of each gropup by element
Sum : Value of the field selected for sum for each record *grouped by number
Example:
1)In your report "111" , its stright group by on the type , number of string type field across all the table is 47,283
2)In your "22222", for the same : Open these records in a separate tab, group by choice field , you wi;ll see something like this
now , go and get choice values for each of these types i.e
now calculate i,e
12577*0 +311858*0 +4204*1+722*2+2505*3+5*4=13,183 which is less than count
Report(in my PDI) : Count
Sum:
Hope this helps!!
