YTD

[stephenedberkg]

MTD

=Sum({<Years={$(=Max(Years))},MonthIDS= {$(=Max(MonthIDS))}, Month=,Year=>} Aggr(If(Only({1}MonthID) = Max(TOTAL <SKU> MonthID) + Only(TOTAL <SKU> OrderLockPeriod),

Sum({<Years={$(=Max(Years))},MonthIDS= {$(=Max(MonthIDS))}, Month,Year=>}Arrivals)), SKU, MonthID))

how to write this MTD expression into YTD?

i want to change the bold font month id into YTD format?

[Chanty4u]

chk dis

YTQ, QTD, MTD and WTD

[stephenedberkg]

=Sum({<Years={$(=Max(Years))},MonthIDS= {$(=Max(MonthIDS))}, Month=,Year=>} Aggr(If(Only({1}MonthID) = Max(TOTAL <SKU> MonthID) + Only(TOTAL <SKU> OrderLockPeriod),

Sum({<Years={$(=Max(Years))},MonthIDS= {$(=Max(MonthIDS))}, Month,Year=>}Arrivals)), SKU, MonthID))

change this expression into YTD?

i attach the sample