Percentage calculation when using Max function

[kkkumar82]

All,

I have faced a issue today on the percentage calculation issue, where in the numerator is a sum value when as the denominator is a max

value, the individual row value percentages are looking correct but the grand totals were incorrect.

Just attaching a file, with a sample, hope it explains my problem.

[kkkumar82]

All,

This is only a sample I want to check how we can get the percentage correctly even we are using Max() function

The solution for the above sample pretty simple is to use Sum(MarksScored) / Sum(MaxMarks) but I was trying

whether we can get it if we still use Max() for Sum() in the above expression.

Thats all the story ends...

Thanks Sunny once again

[sunny_talwar]

Awesome