Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I wish to add a year to date function to one of my expressions, but rather then it running from the current date I would like it to run from July. Is there any way that I am able to do this?
Thanks
Try something like this to get this years sales upto and including July:
sum({<Year={'$(=year(today())-3)'},Month={'<=7'} >} Sales)
This assumes you have a Year and Month field (and a Sales field)
Try something like this to get this years sales upto and including July:
sum({<Year={'$(=year(today())-3)'},Month={'<=7'} >} Sales)
This assumes you have a Year and Month field (and a Sales field)
Hi Gysbert,
the -3 in the expression "year(today())-3)", what is that for?