Sum: All but

[#1]

Hi,

I've got some syntax problems when Im trying to sum all cleints but one (Client A), no matter the current selections.

Right now my expression looks like this:

Sum( {<~Client = {“*Client A*”}>} [Settlement amount] )

Sample attached.

Any ideas?

Kind Regards,

Olle

[veidlburkhard]

Hi Olle,

use this expression: sum( {<Client = {'Client A'}>} [Settlement amount] )

This will work...

Burkhard

[ashfaq_haseeb · Accepted solution]

Hi,

Try below

To Show all except A

====================

sum( {<Client -= {'Client A'}>} [Settlement amount] )

To show only A

===========

sum( {<Client = {'Client A'}>} [Settlement amount] )

Regards

ASHFAQ

[#4]

Thanks Ashfaq!