Filter a table with a calculated dimension

[#1]

Dear Friends,

Why this line does not work:

a calculated dimension: =if(DateTask= $(=aggr(max(DateTask),WorkOrder)),WorkOrderTask, null())

Thanks in advance,

Javier Pozo

[Miguel_Angel_Baeyens · Accepted solution]

Hello Javier,

You don't need to use $() in a condition like that, so try

=if(DateTask = aggr(max(DateTask),WorkOrder), WorkOrderTask, null())

Hope that helps

[#3]

Angel,

You are right it works.

Thanks again

Javier Pozo