Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
PFA variable, I have a variable which shows 24M (Months)stock values.
how to adjust this variable to exclude the latest month?
stalwar1loveisfailsureshqvjontydkpiarvind1494kush141087
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
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)