Totals Function

[risabhroy_03]

I have a measure Weight whose sum value is 24108257.27 and Totals is set to Auto.

When I set Auto to SUM my weight increases by a value of 9.

Please help.

[Rohan]

Hi,

Are you using Sum (distinct weight) ? that's why when total is set to auto it is taking distinct weights sum & when you change auto to sum then the value increases..

[risabhroy_03]

No, I am not using distinct

[Rohan]

can you share a screenshot or something like what expression you are using ?