Skip to Content
0
Former Member
May 11, 2010 at 11:02 AM

Formula on ROWS

30 Views

Dear All ,

I am writing one query on an infocube in which i have to do year to date(YTD) comparision of a key figure and then subsequently calculate its growth % also.

eg. Category YTD (Current year) Volume YTD (Previous Year) Volume Growth%

ABC 50 30 (50-30)/30*100

I am able to display till YTD(Prev Year) , but unable to calculate the growth%.

In my infocube i have category & its volume according to year , therefore i am able to display till YTD.

My volume is coming in a single key figure only.

But how to calcualte Growth% in query itself.

How to apply formula on keyfigures in a row??

Kindly help.

Regards,

Sonali