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

[MK_QSL]

May be try this

Growth

=(( (SUM({<MONTH=>}  [Gross Sales Amount]) - SUM({<MONTH=>}   [Sales Return Amount]) )

-above((SUM( {<MONTH=>} [Gross Sales Amount]) - SUM( {<MONTH=>} [Sales Return Amount]) )

,12))/above((SUM( {<MONTH=>} [Gross Sales Amount]) - SUM({<MONTH=>}   [Sales Return Amount]) ),12)) * 100

[sunny_talwar]

And may be this to the other expression:

YTD Sale

(Sum({<Yea r=, Quarter =, Month =, FiscalYear = {">$(vFY)"}, [Posting Date] = {">=$(=QuarterStart(Min({<Month =>}[Posting Date]),4))<=$(=MonthStart(Today())))"}>} [Gross Sales Amount]) -Sum({<Year =, Quarter =, Month =,  FiscalYear={">$(vFY)"},[Posting Date]={">=$(=QuarterStart(Min({<Month =>}[Posting Date]),4 ))<=$(=MonthStart(Today())))"}>} [Sales Return Amount]))/100000

[prma7799]

I tried but values are wrong

[sunny_talwar]

Can you elaborate on what do you mean when you say values are wrong?

[prma7799]

Hi Sunny,

When I applied above solution then my growth values  are shoving me wrong.

Thanks

[sunny_talwar]

I hope you have replaced MONTH with your MonthField (Whatever its called) and then tried it? I see no reason why your expression which worked earlier won't work now. Because all Manish prescribed is to help your expression not change based on any selection made in the MonthField.

Would you be able to share a sample if you are still not able to figure it out?

[prma7799]

PFA

[MK_QSL]

Where is vFY in your variable definition?

[prma7799]

vFY =Year(addyears(max(Date),-4))