Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Sample data file is attached from where i have to set an expression which will give me total sales of value between days.
Below are the examples which i have set the expressions, but it does not return the value that is expected.
sum({<MONTH= {"$(=getfieldselections(MONTH))"},DAY = {'>=$(vStartDate) <=$(vToday)'}>}SALES)
sum({<MONTH= {"$(=getfieldselections(MONTH))"},DATE = {"$(= '>=' & date(vStartDate) & '<=' & date(vToday))"}>}SALES)
Example: Total current months sales for last year is 77k but i need to see the sales till date for last year (1dec2017 - 18dec2017) which is 48K.
Thanks,
MAK.
Try :
For MTD of last year
sum({<Year, Month, Date={"<=$(=date(addyears(today(1),-1)))>=$(=date(addyears(monthstart(today(1)),-1)))"}>}Value)
Try :
For MTD of last year
sum({<Year, Month, Date={"<=$(=date(addyears(today(1),-1)))>=$(=date(addyears(monthstart(today(1)),-1)))"}>}Value)