Condition in Expression

[madmax88]

Hi,

I have a problem with an expression in set analysis. I have 3 Dimension (Customer, Product A, Product B) and a Value . e.g.

Customer, Product A, Product B

M, ,5

P,5,10

T, , 

Now I need an expression which sum the Value of Dimension B If the Value of Dimension A is null, else it should take the Value of B or null if both dimension don't have any value. 

Is this possible?

[Seyko]

Hello,
Can you show us your expression?
cordially.

[danilodalosse]

Hi @madmax88 ,

sum({<[Product A]={"=Len([Product A])=0"}>}[Product B])

[bhargav_bhat]

Can you share sample data and the output you require
Thanks,
Bhargav

[madmax88]

Hi,

There are is my expression which is not working:

IF((Count({$<Product={'A'}>} Distinct(CUST_ID))>0,0,Count({$<Product={'B'}>} Distinct(CUST_ID)))

Example Data: Result should be 2 (Cust 4 and 5 only have Product B and not A, but Cust 3 has both product and therefor nothing should be counted for Cust 3.

CUST_ID	Product	Order ID
1	A	12
2	A	13
3	B	14
3	A	15
4	B	16
5	B	17
6	A	18

[madmax88]

this worked with one adaption 😉

(Count({$<[Product]={"len(A)=0"},[Product]={'B'} >} Distinct(CUST_ID))

[danilodalosse · Accepted solution]

@madmax88 

if worked it's ok, but I'm not sure after to see your data.

Try to use like this bellow please. I believe to be better 

Count({<Product={B},CUST_ID={"=sum(Aggr(Count({<Product-={B}>}CUST_ID),CUST_ID))=0"}>}Distinct CUST_ID)

[madmax88]

You're right. It seems not to work after checking detail data. It took me now both (A and B). 

With ur new expression it works, Thanks!

[danilodalosse]

Very good! Tks