Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two columns in the same table customer and currency as show below
customer, curreny
A , -
B ,1$
C ,1r
1 ,1r
2 ,1$
3 ,1r
- ,1$
I need to replace all null and numeric values in customer based on currency
example if customer=1 and currency=1$ or null i need to show a special instead of number or null in customer class
can anyone suggest how to achieve this.
Thanks in advance.....
Add Calculated Dimension:
=if(customer=1 AND curreny='1r' OR curreny='','Special',0)
Replace the Special with whatever "Special" do you want
Hi Robert,
I want this condition to be applied for all numeric and null values in customer field depending on curreny value can you please give example how to handle it.
Try
=IF(ISNUM(customer) AND curreny='1r' OR curreny='','Special',0)