Good Morning,
I am geeting wrong values after i do group total.
Let me explain clearly.
I have 1 row group and 1 column group.
I am adding totals for row group.
Ex - Amount field is there
Total - sum(Amount)
But i am getting wrong values.The total is not matching.
Then i used =Sum(Max(amount))
It is working and again for some time i am getting wrong values in total.
Then i changed at row level - earlier it was field!amount.value.
I changed it to =Max(field!amount.value)
and in total =Sum(Max(amount)).
then i am getting values wrong in table level.But total is matching now.
Please suggest me what can be done for these kind of total issues.in Groupings
Regards.
Have a great day.