on 01-31-2021 6:09 PM
Hi Team ,
As per the my requirement I have created a Dimension with case condition with is logic but not generate expected values :output must have customer order date wihout null values
Alter How can we implement in WebI Logic which was mentioned in the below
Case
When GENDER='M'
AND CUSTOMER PURCHASEDATE =NULL
AND CUSTOMER ORDERDATE=NULL
AND
CUSTOMERORDERDATE=LEAST(CUSTOMER ORDER,CUSTOMER PURCHASE) Then CUSTOMER ORDERDATE else 'N' as End
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.