Above function calculation

[prma7799]

Hi All,

I have dimension as QurterYear and I am getting all qurteryear values in Bar graph but when am writing below code for Growth value then am not getting exact growth value for respected quarter.

=(( (SUM(  [Sales Amount]) - SUM(  [Return]) )

-above((SUM([Sales Amount])- SUM(  [Return ])) ,4  )) /above((SUM(  [Sales Amount]) - SUM(  [Return])) ,4)) * 100

Thanks

[MK_QSL]

What is 4 here?

[danansell42]

Hi

Are you trying to do a quarter on quarter growth?

I noticed you have put an offset of 4 and if its meant to be quarter on quarter then i would assume you should use 1 instead.

Also you might need to use the aggr function too.

Please try the below and hopefully this does what is required

=num((((SUM([Sales Amount]) - SUM([Return]) )-aggr(above((SUM([Sales Amount])- SUM([Return])) ,1,1  ),QuarterYear))

/aggr(above((SUM([Sales Amount])- SUM([Return])) ,1,1  ),QuarterYear)),'#,##0%')

[danansell42]

Hi

Did this solve your query?

Please mark as correct to help other community users if it did.

Thanks

Dan

[Anil_Babu_Samineni]

=(( (SUM(  [Sales Amount]) - SUM(  [Return]) )

-above((SUM([Sales Amount])- SUM(  [Return ])) ,4, 0  )) /above((SUM(  [Sales Amount]) - SUM(  [Return])) ,4, 0)) * 100