I assume that you want to calculate this in the UI. But then you have to consider that there are almost always several values possible within a single field. So your condition Date2 = 'T' cannot be evaluated: The field reference "Date2" will return NULL if there is more than one possible value.
So either you need to use aggregation functions, e.g. Max(Date2) instead of Date2, or you need to use a dimension where there is only one Date2 and one STATUS_CD per dimensional value, e.g. by wrapping the whole expression in an Aggr().
OK. Your dimension is "ID" and each ID has a "Date2" corresponding to closing date? And if it hasn't been closed, the "Date2" contains a 'T'?
But what about the field "Date"? How is that linked to these tickets?
You can probably create that table using the following: Dimension: ID Measure 1: Max(Date2) // Showing the (largest) closing date or blank (for 'T') Measure 2: If(Only(Date2)='T' or Only(Date2) > Max(Date),'Open',STATUS_CD)
Max(Date) is returning the (largest/latest) selected date.
I suspect that what you want to do, is to have a condition on the Date, and thereby assign 'Open' or 'Closed'. But to do this, you need to specify that you want to loop over the dates, and evaluate each date separately. This is done using =Aggr(..., Date)
Try the following as dimension: =Aggr(If(Only({<Date=>} Date) <= Date(Max(total Date)), 'Open', 'Closed'), Date)
.png "Former Employee"){kind=icon}
