Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
go to list box properties-> field-> expression (Bottom of the field) -> write formula
=if(aggr(sum(InvNetSales),CustomerShortName)=0,CustomerShortName)
maybe
if(aggr(
(sum({<TransactionType = {'INVOICE'}>}#InvNetSales)- Sum({<TransactionType = {'CreditNote'}>}#InvNetSales)
,
Customer)=0,Customer)
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
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
in list box general is this only..where can i write?
go to list box properties-> field-> expression (Bottom of the field) -> write formula
=if(aggr(sum(InvNetSales),CustomerShortName)=0,CustomerShortName)