Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I'm trying to create a misure based on the current date. I'd like to sum the differences between two dates, based on the finish date that must be not after today.
So, I'd like to achieve something like:
SUM({<FinishDate <= {Today()}>} INTERVAL(Finishdate - StartDate, 'd'))
Obviously the formula is wrong, how could I achieve that?
Many thanks
Just create a table:
as dimension:
StartDate
as measure:
today(1)-StartDate
or maybe:
if(FinishDate>today(1),today(1)-StartDate,FinishDate-StartDate)
example:
SUM({<FinishDate = {'<=$(=Today())'}>}INTERVAL(Finishdate - StartDate, 'd'))
That's exactly that I wanted, many thanks!
I guess I have now understood how it works with > and < comparison...!