Firstsorted value set analysis exclusion of Year selection

[vishsaggi]

Hello All,

Seems like tricky, but trying to figure out how to exclude current selections in a table with Firstsortedvalue expressions.

PFA the sample and inside a text box that explains the problem.

Please let me know if i have not made it clear.

Appreciate your time.

Many thanks,
V.

[Nicole-Smith · Accepted solution]

Change expression for Admit Date to:

FirstSortedValue({<Year=>}Admit_Date, Aggr(only({<Year=>}Date(Charge_Date, 'MM/DD/YYYY ')),Patient_Name, Encounter, Charge_Date))

The "{<Year=>}" tells the expression to ignore any selections in the Year field.  You can add other fields (like month) if you wanted to treat them the same way, i.e. {<Year=, Month=>}

[vishsaggi]

Superb,. Thanks very much Nicole for the expression, it worked. Ha i completely forgot about this Only() and trying to complicate the expression. Appreciate your time.