Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to calculate the YTD Sales and MTD Sales, QTD Sales but Make sure my calendar year starts with the 1-OCT.
Thankyou,
Siva
Hi Siva,
Use a master calendar with flags, check out the search box at the top right, it will help you a lot
HI,
There are some functions available to compute .
1) YearStart(), YearEnd()
Sum({<Date={">= $(=YearStart(max(Date)) ) <= $(=max(Date)) "},YEAR=,MONTH=>}SALES)
2) MonthStart(), MonthEnd()
Sum({<Date={">= $(=MonthStart(max(Date)) ) <= $(=max(Date)) "},YEAR=,MONTH=>}SALES)
3) Quarterstart(), QuarterEnd()
Sum({<Date={">= $(=QuarterStart(max(Date)) ) <= $(=max(Date)) "},YEAR=,MONTH=>}SALES)