Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, all,
I have this YTD calculation for metric Sum({$<FiscalYear={$(=Max(Year(Saledate)))}>}Sales)
This works great for current month.. But it does not work when I select Calendar filter (To and From dates) to Feb.. It gives MTD number.. Instead I would need from year beginning till max month selected..
I have declared in load editor Num(Month(SalesDate)) as MonthNum,
I also tried giving this YTD calc :
Sum({<FiscalYear={$(=Max(Year(Salesdate)))},MonthNum={"<=$(max(MonthNum)+1)"}>}Sales) but this does not work..
Can someone help me how to proceed.
Hi,
Try this one: Sum({<SalesDate ={">=$(=YearStart(Max(SalesDate)))<=$(=Date(Max(SalesDate)))"}>}Sales)
It will return YTD Sales of the max Sales Date
Hi,
Try this one: Sum({<SalesDate ={">=$(=YearStart(Max(SalesDate)))<=$(=Date(Max(SalesDate)))"}>}Sales)
It will return YTD Sales of the max Sales Date
Thank you very much @Quy_Nguyen . This solution worked perfectly!