Set analysis: sum if date before today

[Anonymous]

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

[OmarBenSalem]

Just create a table:

as dimension:

StartDate

as measure:

today(1)-StartDate

or maybe:

if(FinishDate>today(1),today(1)-StartDate,FinishDate-StartDate)

example:

[m_woolf · Accepted solution]

Maybe:

SUM({<FinishDate = {"<=$(=Today())"}>}              INTERVAL(Finishdate - StartDate, 'd'))

[sasiparupudi1]

SUM({<FinishDate = {'<=$(=Today())'}>}INTERVAL(Finishdate - StartDate, 'd'))

[Anonymous]

That's exactly that I wanted, many thanks!

I guess I have now understood how it works with > and < comparison...!