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.

[vinieme12]

The Expression is correct

This is how the Expression total for MAx is being calculated

Max(MarksScored) = 89

Max(Marks) = 100

so 89%

if for any of the subjects max marks were 200 then Expression Total would show = 89/200

Hope this helps

[sunny_talwar]

Or this:

Marks Scored

Max(Aggr(Sum(MarksScored), Sno))

Max Marks

Max(Aggr(Sum(MaxMarks), Sno))

[kkkumar82]

Hi sunny,

The original problem I have got fixed , using aggr, but the sample I have provided , if you see that, the percentage

should be 556/700 = 79.43% but because of using Max() the percentage is coming as 89%, any fix for this.

[sunny_talwar]

You want 79.43? I thought you wanted 89%. To get 89%, why not just use this?

Sum(MarksScored)/Sum(MaxMarks)

[kkkumar82]

For this case , I can use Sum() but is there a way can we get with Max()

[sunny_talwar]

I have no idea what you are looking for Kiran. Do you want to expand a little on what you are doing?

[kkkumar82]

As per your suggestion I can go with Sum(MarksScored)/Sum(MaxMarks) but I am asking you whether is it possible to the percentage 79 still using Max() function.

Hope I am clear this time

[sunny_talwar · Accepted solution]

I am still not sure, but may be try this

Sum(Aggr(Max(MarksScored), Sno))/Sum(Aggr(Max(MaxMarks), Sno))

[kkkumar82]

You picked it this time as always ..........