Calculated expression?

[Anonymous]

Hi,

I am trying to calculate a rest, but that only display open records but I am not being able to do it.

I am trying

Today()-[DaysSinceOpened]

But if I try to add the exclusion as

={$<Status -= 'Closed'>},Today()-[DaysSinceOpened]

it's not working, is there a way to make this work?

[Anil_Babu_Samineni]

I am assuming, You are doing set analysis with Interval. Is there any chance to share whole expression?

[sunny_talwar · Accepted solution]

May be try this:

Only({$<Status -= 'Closed'>} Today() - DaysSinceOpened)

[sunny_talwar]

Or this:

If(Status <>'Closed', Today()) - Only({$<Status -= 'Closed'>} DaysSinceOpened)