I am having similar issues with Subgroups. How many IFF can I nested into one? I have a company with 5 different locations and I cannot subgroup then. This is what I have. IIF (CustomProperty1 LIKE '*Downtown*', 'Downtown_Location', IFF (CustomProperty1 LIKE '*Tempe*', 'Tempe_Location', IFF (CustomProperty1 LIKE '*Dental*', 'Dental_Location', IIF (CustomProperty1 LIKE '*Henderson*', 'Henderson_Location', IFF (CustomProperty1 LIKE '*Pahrump*', 'Pahrump_Location','Owens_Location')))))
I am having similar issues with Subgroups.
How many IFF can I nested into one?
I have a company with 5 different locations and I cannot subgroup then.
This is what I have.
IIF (CustomProperty1 LIKE '*Downtown*', 'Downtown_Location', IFF (CustomProperty1 LIKE '*Tempe*', 'Tempe_Location', IFF (CustomProperty1 LIKE '*Dental*', 'Dental_Location', IIF (CustomProperty1 LIKE '*Henderson*', 'Henderson_Location', IFF (CustomProperty1 LIKE '*Pahrump*', 'Pahrump_Location','Owens_Location')))))
Returns (empty)