custom formula in list box

[#1]

Hi

In a list box I have added in the custom expression below in order to only bring in the Drivers that are actually used within the data (ie there are around 30,000 set up in the system but only 3,000 with data on).

The formula below appears to work as a much reduced list of drivers are brought through into the list box.

However the issue i have is that when one of the drivers is selected in the list box the rest disappear completely out of the list box, how can i edit my formula/settings so that the other options stay in the box and appear greyed out as per the standard formats of a list box?

I have tried adding in {1} in the two sum brackets but this doesnt change the result

=

Aggr(If(
(
fabs(ROUND(Sum(COST)))+fabs(round(sum(revenue)))
) <>0, [Driver Type]),[Driver Type]
)

[jagan]

Hi,

Try like this

=Only({1}

Aggr(If(
(
fabs(ROUND(Sum({1}COST)))+fabs(round(sum({1}revenue)))
) <>0, [Driver Type]),[Driver Type]
))

Regards,

Jagan.