Custom formula in 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]
)

[jonathandienst]

Hi

Try

=Aggr(If(

  (fabs(Round(Sum({1} COST)))+fabs(Round(Sum({1} revenue)))) <> 0,

  [Driver Type]

  )

,[Driver Type])

HTH

Jonathan

[ljackson]

In the presentation tab, ensure that suppress zero values is unchecked.