Set Analysis = Null Values

[prees959]

Hi,

I am loading in two tables SalesCountryA & SalesCountryB  which are linked by Sales Rep.

If I want to sum the the TotalSalesA from SalesCountryA where there is no corresponding sales for that Rep in SalesCountryB - could I do this in set analysis?

Something Like : sum({<sum(TotalSalesB is null>}TotalSalesA)

Thanks for any help!

Phil

[Anil_Babu_Samineni]

May be these?

sum({<TotalSalesA = {' '}>}TotalSalesA)

OR

sum({<TotalSales = {"=Sum(TotalSalesA) = 0"}> + <TotalSales = {"Sum(TotalSalesA) = ' ' "}>}TotalSalesA)

OR

Sum(If(IsNull(TotalSalesA), TotalSalesA))

[aarkay29]

May be something like this

sum({<Rep=e({1<country={'B'}>})>}TotalSalesA)