Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a column "Promotion code" in my table , I am creating pivot table, in that I want to see if the customer used a promo code or not ,for that I want to convert my feild value for example under if it is null or - it must say No and if there is promode like New20 then it is Yes. I am not doing this at script level , I am doing this at chart or expression level.
I have used if([Promo Code]=0,'No','Yes') but it seems to give me all Yes for some reason.
Thanks in advance.
May be this?
if( Len(trim([Promo Code]))=0,'No','Yes')
May be you have Nulls instead of 0. Can you check handle the nulls. May be this?
if([Promo Code]=0 or [Promo Code] = 'Null' or [Promo Code] = '-' or IsNull([Promo Code]),'No','Yes')
Try this,
if(isnull([Promo Code]),'No','Yes')
Regards,
Pratik
Thank you all.