values getting changed

[prma7799]

Hi All,

I have 2 expression  in the attached.

PFA

My question is when I select Months my 2 expression "Growth" values changed.

Thanks

[tresesco]

Try redefiing the variable like:

vFY =Year(addyears(max( {<MonthName>}Date),-4))

You might have to include other time dimensions too to bypass their selection effect.

[prma7799]

Hi Manish,

In expression there is no need to FiscalYear={">$(vFY)"} (vFY).

I want when i select month then growth figure is come properly

Growth formula is  ((CYMonth - LYMonth) / LYMonth )*100

Thanks

[prma7799]

Hi All / tresesco, jagan , sunindia , swuehl , maxgro,

Any solution on this ?

Thanks