Converting value into Yes or No

[madhuqliklondon]

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.

[tresB · Accepted solution]

May be this?

if( Len(trim([Promo Code]))=0,'No','Yes')

[Anil_Babu_Samineni]

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')

[mostwanted123]

Try this,

if(isnull([Promo Code]),'No','Yes')

Regards,

Pratik

[madhuqliklondon]

Thank you all.