Growth

[upaliwije]

Hi Friends

I attach h/w my QV document where my formula for growth calculation does not work. pls look into this and correct me.

[sunny_talwar]

Use this expression:

=Sum(Premium)/Before(Sum(Premium)) - 1

Output:

[buzzy996]

problem with ur previous year expression calculation,try to modify tht part ..and see?

[Qrishna]

try this. it works:

=(sum( {<YEAR={$(=max(Year))}>} [Premium] ) - sum( {<Year={$(=max(Year)-1)}>} [Premium] ))

/Fabs(sum( {<Year={$(=max(Year)-1)}>} [Premium] ))*100

Thanks

[upaliwije]

Thanks sunindia

Your expression is working. But in my actual data table there is another filed and if I apply your formula it does not work. Kindly have a look at my QV document attached now !

[upaliwije]

Your expression does not work

[sunny_talwar · Accepted solution]

Update: Reattaching the file as I think I attached the earlier one without saving

For me it seems to be working:

=Sum({<DESC={'GP'}>}AMOUNT)/Before(Sum({<DESC={'GP'}>}AMOUNT))-1

[upaliwije]

Thanks a lot it is working

[sunny_talwar]

No Problem