How to exclude latest month from variable?

[ramcena306]

Hi All,

PFA variable, I have a variable which shows 24M (Months)stock values.

how to adjust this variable to exclude the latest month?

stalwar1‌loveisfail‌sureshqv‌jontydkpi‌arvind1494‌kush141087‌

[jyothish8807]

Try this:

sum({1<

CALYEAR= {"$=(max(year))"} , CALMONTH={*}-{"$=(Date(Max(Month),'MMM'))"}

,PROD_CALMONTH=$::PROD_CALMONTH

,PROD_CALYEAR=$::PROD_CALYEAR

>}MON24)

I would recommend to use a Date filed instead of using Year and  month field.

You have define if you are using "Prod_Cal" month or just "cal month" fields for your analysis.

Br,

KC

[sasiparupudi1]

Try something like below

v_KPI_Stock_24M_Precalc ::

sum(

//basic calculation for 24 month stock based on precalculated MON24

//fields to be considered for selections

{1<

CALMONTH=$::CALMONTH

,CALYEAR=$::CALYEAR

,PROD_CALMONTH=$::PROD_CALMONTH

,PROD_CALYEAR=$::PROD_CALYEAR

     >-1<CALMONTH={"$(=Date(MonthStart(Today()), 'MM'))"},CALYEAR={"$(=Year(Today()))"}>

}

     MON24)