show list box field with conditional

[stephenedberkg]

my list box have the customer

i want to show the list box customer sales=0 only.

(sum({<TransactionType = {'INVOICE'}>}#InvNetSales)

- Sum({<TransactionType = {'CreditNote'}>}#InvNetSales))  = 0

the above formula is my sales i want to display the 0 sales customer only in my list box

[maxgro]

maybe

if(aggr(

     (sum({<TransactionType = {'INVOICE'}>}#InvNetSales)- Sum({<TransactionType = {'CreditNote'}>}#InvNetSales)

     ,

     Customer)=0,Customer)

[stephenedberkg]

maxgro

Where i want to write this formula in expression tab Definition or Conditional?

if i write in definition i get like this

if i write in conditional i get like this

[maleksafa]

you need to write it in the General Tab, where you select the dimensions from the list. at the end of the list there is expression, there you should input this expression

[stephenedberkg]

in list box general is this only..where can i write?

[stephenedberkg · Accepted solution]

go to list box properties-> field-> expression (Bottom of the field) -> write formula

=if(aggr(sum(InvNetSales),CustomerShortName)=0,CustomerShortName)