count records not selected in a list box

[tinkerz1]

Hi,

If I have a list box with selections I can use count ([ABC]) in a straight table to to count those selected records.

But how can make a straight table with an expression counting all the not selected fields?

Thanks.

[marcus_sommer]

Getexcludedcount([ABC]) should work.

- Marcus

[sinanozdemir]

Hi Neil,

I use Count({1 - $} Distinct Dimension) function:

[tinkerz1]

This does not work for me

I copy the object and change the formula to Getexcludedcount([ABC]), the expression say 'OK' but nothing

I though I have to use getfieldselections or something?

[tinkerz1]

Also this works

=

count({$<[Forum Reference (June)]=e([Forum Reference (June)])>}[Forum Reference (June)])

[tinkerz1]

This does not work for me, I think it is down to using an alternate state in the list box and the straight table, they are the same alternate states, how do I point the count statement at the alternate state?

[marcus_sommer]

Is this solved yet? It's not clear if you answered always to yourself. If it's not then please provide more context how do you want to use it and why.

- Marcus