Ignore all selections set expression with sum function inside

[#1]

Hi,

I'm having an issue. I need to customers which debt balance <>0.00. And this calculation can;t change because after that i will use this calculated expresion in another calculation

I can easily calculate all customers and it is not changing an any selections - this formula is working fine:

=Count({1<CustomerCode=>} CustomerCode)

but if i put a sum expression inside then when i select a customer the result is 1 - it counts the selected customer

This expression is working wrong

=Count({1<CustomerCode={"=Sum(Balance)<>0.00"}>} CustomerCode)

Can you give me a right direction how to achieve it?

thanks

jja

[#2 · Accepted solution]

Julius,

perhaps write an inner set into the sum:

=Count({1<CustomerCode={"=Sum({1} Balance)<>0.00"}>} CustomerCode)

Fabrice

[MK_QSL]

Try something like below..

=Count({1<CustomerCode={"=Sum({1}Balance)<>0.00"}>} CustomerCode)

Or Like something below...

=COUNT({1}IF(Aggr(SUM({1}Balance),CustomerCode) <> 0, CustomerCode))

[#4]

Hi,

Yes. Seems so little i was missing!!! Thank you!

[#5]

Wellcome

So little, it's true

Fabrice