Expression for Ratio

[upaliwije]

Hi Friends

I have follwing pivot tbale in my QV doc

and I want to show Ratio of each item under DES coloum against Gross Premium. I have written the follwing  expression. but It does not show expected valures in Ratio column. Kindly help me to correct my expression.

=fabs(Sum(PL)/sum({<DES={'GROSS_PREMIUM'}>}PL))*100

[chinnuchinni]

can you attach the sample app. then it will easy to reach the requirement.

[upaliwije]

iT is difficult to share sample data

[sunny_talwar · Accepted solution]

Try this

=fabs(Sum(PL)/sum(TOTAL <FROM_YEAR> {<DES={'GROSS_PREMIUM'}>}PL))*100

[PrashantSangle]

what is your expected output??

also explain your formula in simple word.

Regards

[upaliwije]

Thanks Sunny!

That is exactly what I wanted. You are precise as usual