While I am using Totals function as 'Auto' it's generating wrong totals (despite summing up the records in the expression) but another filed with same expression but when select Totals Function as 'Sum' giving the right results.
I have a requirement to show the value as KPI where it's automatically considering Auto as Totals function and I don't see any option for that KPI's to change the Totals function from Auto to Sum. Hence, can we use some expression and make the KPI's expression to automatically consider 'Sum' but not 'Auto'?
Attached the qvf, screenshot and source file. Please help. Thanks.