Adding distinct to this formula

[#1]

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.

[lironbaram]

hei

try to use

aggr(IF(Master.formType like '*79*','Yes',NULL()), %KEY_CARS)