Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a straight table which is duplicating on the %KEY_CARS field.
How can I have this formula work on only distinct %KEY_CARS values?
=IF(Master.formType like '*79*','Yes',NULL())
thanks.
hei
try to use
aggr(IF(Master.formType like '*79*','Yes',NULL()), %KEY_CARS)