Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need a data from 2020 Jan to now (today),then I created two variables,
Let vStartofdDateRange =num(date('01-01-2020','DD.MM.YYYY));
Let vEndofDateRange=num(today()-1);
How I will get data then
Sum({$<datenum= {">=$(=num(date('01-01-2020','DD.MM.YYYY)))<=$(=num(today()-1))"}>} sal)
try something like above....
What you are looking for is called YearToDate or YTD.
Please have another search for this, since there are already existing many solutions and topics for this problem.