Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
My expression is sum(sales) but i need to modify that as sum(sales) from vYesterday to vPast varisbles.
Thanks..
Can you provide more information? What is vYesterday? What is your date field? It's format... etc etc
HI ,
Please find below.
vYsterday = date(today()-1,'M/D/YYYY');
vPast = date(today()-28,'M/D/YYYY');
Where Date=Today
Thanks..
Sum({$<Date={'>=$(=Date(vPast, 'M/D/YYYY'))<=$(=Date(vYsterday, 'M/D/YYYY'))'}>} Sales)
Hi,
It's not working..
Thanks..
what is date field name ?
Field Name =Date
Thanks..
Sum({<Date = {">=$(=Date(Today()-28,'MM/DD/YYYY'))<=$(=Date(Today()-1,'MM/DD/YYYY'))"} } Sales)
Or
Sum({<Date = {">=$(=Date(Today()-28,'M/DD/YYYY'))<=$(=Date(Today()-1,'M/DD/YYYY'))"} } Sales)
I have doubt on your "Date" field format ...