set analysis with conditions

[stephenedberkg]

i want to calculate the return product analysis.

sum(sales) <0 that is my return sales.

i want to take the count of total number of return product.

how to write this concept in set analysis formula?

Thanks in Advance

[gautik92]

try this

Sum(if((Sum({<Year = {$(=Max(Year))},TransactionType={'INVOICE'},Month=>} #InvNetSales) -

Sum({<Year = {$(=Max(Year))},TransactionType={'CreditNote'},Month= >} #InvNetSales)) <0,1,0))

[gautik92]

if(

(Sum({<Year = {$(=Max(Year))},TransactionType={'INVOICE'},Month=>} #InvNetSales) -

Sum({<Year = {$(=Max(Year))},TransactionType={'CreditNote'},Month= >} #InvNetSales)) <0,count(Distinct CustomerID)

)

[jonas_rezende]

Hi, Stephen Edberk.

Try

Count (Distinct {<Customer= {"=Sum({<Year = {$(=Max(Year))},TransactionType={'CreditNote'},Month= >} #InvNetSales)) <0"}>} Product)

Hope this helps!