I want to calculate the number of days a case was open but only if the case was not closed
I have a field titled "Date Case Opened" and want to calculate the # of days the case was open but only if the "Date Closed" filed is blank.
Forum Discussion
If you care about it being business days only instead of the full week you can also do it this way.
if(isNull([Date Closed]),
WeekdaySub(Today(),[Date Case Opened]),
null
)
if(isNull([Date Closed]),
WeekdaySub(Today(),[Date Case Opened]),
null
)