Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Pls help with set Analysis..Sample data & Required Result attached.
Thanks in advance..
Sub2u
Use variables to calculate sales between two dates. Start date will be your Month Start of fiscal year and End date will be the last date of selected month. You can use both these variables to get sales between selected period
set | st_date= | date(monthstart(FirstMonthOfFiscalYear),'YYYY-MM-DD'); |
set | en_date= | date(monthend(Max(SelectedMonthYear)),'YYYY-MM-DD'); |
= sum({<bill_date={">=$(=st_date) <=$(=en_date)"}>}sales)