If condition

[risabhroy_03]

I am facing a challenge - 

I have 2 columns named [Customer Part] and [Internal Part].

If my Customer Part is either Null or Blank, then it should display my Internal Part else Customer Part.

I wrote this -

if(Len([Customer Part]=0),[Internal Part]
,if(Len([Customer Part]>0),[Customer Part])) as [Customer Part Final];

But for all cases, it is just considering the 1st if condition.

Please help

[Vegar · Accepted solution]

Len([Customer Part]=0) will always return 1. The value 1 will be intepreted as true(), so you will always get the Internal parts.

I think you should do this instead:

if(Len([Customer Part]) =0,[Internal Part], [Customer Part]) as [Customer Part Final];