Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenedberkg
Creator II
Creator II

show list box field with conditional

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

1 Solution

Accepted Solutions
stephenedberkg
Creator II
Creator II
Author

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

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

View solution in original post

5 Replies
maxgro
MVP
MVP

maybe

if(aggr(

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

     ,

     Customer)=0,Customer)

stephenedberkg
Creator II
Creator II
Author

maxgro


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

if i write in definition i get like this

listbox definitions.png

if i write in conditional i get like this

listbox conditional.png

maleksafa
Specialist
Specialist

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
Creator II
Creator II
Author

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

listbox general.png

stephenedberkg
Creator II
Creator II
Author

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

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