Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to write below MTD expression in YTD?
=Sum({<Year={$(=Max(Year))},MonthID= {"<=$(=Max(MonthID))"},Month=,Year=>} Aggr(If(Only({1}MonthIDS) = Max(TOTAL <SKU> MonthID ) + Only(TOTAL <SKU> OrderLockPeriod) ,
Sum({<Year={$(=Max(Year))},MonthID= {"<=$(=Max(MonthID))"},Month=,Year=>}Arrivals)), SKU, MonthIDS ))
Stefan where is a sample my friend? Without a sample you are just hoping someone will be able to help, please provide one with the desired solution so that we can help you in best possible way
Dear sunindia
i attached the sample app.
i am using Personal edition so i can't access it. .
i changed the expression for my Requirement
=Sum({<Year={$(=Max(Year))},MonthID= {"<=$(=Max(MonthID))"},Month=,Year=>} Aggr(If(Only({1}MonthIDS) = Max(TOTAL <SKU> MonthID ) + Only(TOTAL <SKU> OrderLockPeriod) ,
Sum({<Year={$(=Max(Year))},MonthID= {"<=$(=Max(MonthID))"},Month=,Year=>}Arrivals)), SKU, MonthIDS ))
may be like this?
=Sum({<Year={$(=Max(Year))},MonthID= {">=$(=Min(MonthID))"},Month=,Year=>} Aggr(If(Only({1}MonthIDS) = min(TOTAL <SKU> MonthID ) + Only(TOTAL <SKU> OrderLockPeriod) ,
Sum({<Year={$(=Max(Year))},MonthID= {">=$(=Min(MonthID))"},Month=,Year=>}Arrivals)), SKU, MonthIDS ))
I don't see any attachment?
Dear Sunny T
i attached the sample help me?
Dear balrajahlawat
this expression also show the MTD Values only