Différence between auto() and sum() in a total function

Alexia_Frn02 — Fri, 19 Mar 2021 12:50:45 GMT

Hello, I am trying to understand why I don't have the same result when I am using Auto in the total function for a measure and when I am using the Sum option.

Could you please explain to me how it is possible ?

I have already red the article "Expression total vs sum of rows" but it did not helped me to understand.

Thank you in advance.

Alexia

Re: Différence between auto() and sum() in a total function

Nicole-Smith — Fri, 19 Mar 2021 20:00:14 GMT

The Auto option uses your calculation for the total whereas the Sum option takes the values in the rows and adds them up.

For example, say you have the following data:

Field1 Field2
A 100
B 100
B 200
C 200
C 300

If you create a table with the following dimension and measure:

Dimension: Field1
Measure: min(Field2)

When choosing Auto, your output will look like this because it applied the Measure (in this case min) across all the values:

Field1 Field2
Total 100
A 100
B 100
C 200

When choosing Sum, your output will look like this because it sums up all of the values of the rows:

Field1 Field2
Total 400
A 100
B 100
C 200

topic Différence between auto() and sum() in a total function in Search the Community

Différence between auto() and sum() in a total function

Re: Différence between auto() and sum() in a total function