Growth formula issue

[prma7799]

Hi All / stalwar1,

I am facing some issue with on formula that is I have to create MoM chart with Growth for that I am using

Dim: = if(MonthEnd<Today(), MonthYear1 )

Expr:

for Sale :

fabs(Sum({<Year=, Quarter=,  FiscalYear={">$(vFYM)"},[PostingDate]={">=$(=QuarterStart(min(PostingDate),4 ))<=$(=MonthStart(Today())))"}>} Amount))/100000

for Growth :

((Sum(Amount)-

above(Sum( Amount),12))/above(Sum(Amount),12)) * 100

VFYM:=Year(addyears(max([Posting Date]),-1))

using above in chart the data is coming properly But I want growth line  I want to show from APR-15

Please find the attach

[sreenivas]

Hi

Add the set conditions in the Growth formula too , as used i the Sales.

[prma7799]

Can you please explain bit more..

[sreenivas]

{<Year=, Quarter=,  FiscalYear={">$(vFYM)"},[PostingDate]={">=$(=QuarterStart(min(PostingDate),4 ))<=$(=MonthStart(Today())))"}>}

Add the set condition to filter data from Apr15 on wards in the expression

((Sum({"set condition"}Amount)-

above(Sum( {"set condition"}Amount),12))/above(Sum({"set condition"}Amount),12)) * 100

[prma7799]

Like this??

((Sum({<FiscalYear={">$(vFYM)"}>}Amount)-

above(Sum({<FiscalYear={">$(vFYM)"}>}Amount),12))/above(Sum(Amount),12)) * 100

[sreenivas]

yes try the below one

((Sum({<FiscalYear={">$(vFYM)"}>}Amount)-

above(Sum({<FiscalYear={">$(vFYM)"}>}Amount),12))/above(Sum({<FiscalYear={">$(vFYM)"}>Amount),12)) * 100

[prma7799]

I tried this but growth figures showing incorrect.

[sreenivas]

can you post sample data

[prma7799]

It is showing like this...

Growth showing only for last four quarter ..

[sreenivas]

Hi Prasanth

check the attached file.