Excluding Sum

[asknyldz]

Hi everyone,

My Data is;

Client	Type	Amount
ABC	ACTUAL	100
DEF	BUDGET	200
GHI	ACTUAL	250
JKL	ACTUAL	150
MNO	BUDGET	300

and My formula is;

sum({<TYPE={'ACTUAL'}>}AMOUNT)

Result = 500

My question is;

I want to sum Actual with Excluding "GHI" client. How can i reformula this.

Result Should be = 250 (ABC+JKL)

Thank you

[vincent_ardiet · Accepted solution]

Hi,

sum({<TYPE={'ACTUAL'}>-<CLIENT={'GHI'}>}AMOUNT)

[sunny_talwar]

Or this:

=Sum({<Type = {'ACTUAL'}, Client = e({<Client = {'GHI'}>})>} Amount)

[asknyldz]

Thanks for solutions, that's great.

But i have challenge. I want to sum Actual with Excluding more than 1 client. GHI and JKL

What is the formula?

[sunny_talwar]

May be this:

=Sum({<Type = {'ACTUAL'}, Client = e({<Client = {'GHI', 'JKL'}>})>} Amount)

or

=Sum({<Type = {'ACTUAL'}>-<Client={'GHI', 'JKL'}>}Amount)