Hello,
I have a scenario , need to prepare a standard expression for
1.Monthly
2. YTD
3.Last twelve months
sum({<$(vCYPeriod),Scenario={'CPL_ACT'}>}Value) [STANDARD FORMULA]
vCYPeriod=Pick(match($(vPeriodType),1,0,2),vPeriodTypeCYMTH,vPeriodTypeCYYTD,vPeriodTypeLast12Months)
vPeriodTypeCYMTH=[Fiscal year]={'$(=$(vCurrYear))'},[Posting period]={'$(=$(vCurrMonth))'}
vPeriodTypeCYYTD=[Fiscal year]={'$(=$(vCurrYear))'},[Posting period]={"<=$(=$(vCurrMonth))"}
vCYPeriod changes as per I select the variable as Monthly,YTD and Last twelve months. For Last twelve months the formula is
<[Fiscal year]={'$(=$(vLast12MonthsStartYear))'},[Posting period]={">=$(=$(vLast12MonthsStartMonth))"}> + <[Fiscal year]={'$(=$(vCurrYear))'},[Posting period]={"<=$(=$(vCurrMonth))"}>
| vLast12MonthsStartMonth | if($(vCurrMonth)=12,1,$(vCurrMonth)+1) |
| vLast12MonthsStartYear | if($(vCurrMonth)=12,$(vCurrYear), $(vPrevYear)) |
