Count all something when a value is not ...

[#1]

Hi,

We normally use Count({$<Field={'Value'}>}something)

How about count all something when the Field is NOT 'Value'.

Is there any all-in-one expression instead of reaching the result through straightforward multiple calculations.

Thanks.

[surender_mehta · Accepted solution]

Hi,

You can first count all the values and then subtract from all to the selective values

e.g.

=count({<,Field={"*"}-{"Value"}>}TxnID).

Try this , hope will work

regards

Surender Mehta

[#3]

Works fine.

Thanks.