custom list box

[#1]

Hi

I have added in the custom expression below in order to only bring into the list box the Drivers that are actually used within the data (ie there are around 30k set up but only 3k 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 is selected 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?

=

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

[#2]

Hi Jono

did you untick "mask excluded values" in tab General ?

best regards

chris

[#3]

Hi

No that box isnt ticked

Jon

[#4]

Hi,

If you use Aggr then the unselected values will be disappear. So, instead of using Aggr, you just use IF condition.