Skip to Content
0
Jan 31, 2021 at 06:09 PM

How to implemented nested if condition in WebI

41 Views

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