Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a straight table that has address information on it.
I would like the dimension to say If(Address1) is null then display TAddress1 but it isn't working. This is my exact dimension
=IF(([Address 1]=null()),TAddress1)
What am I doing wrong?
Ok. I think this works for me. =IF(len([Address 1]=null()),TAddress1) Thanks for the help!
=IF(isnull([Address 1]),TAddress1)
Yes, I should of put that down but I did try that already and it didn't work. Thanks Though!!
Could it be that it is not an null value?
Try this:
IF(len([Address 1])=0,TAddress1)
That didn't work either. But what do you mean that it is not a real null value?
It could be just an empty string, ''.
Ok. I think this works for me. =IF(len([Address 1]=null()),TAddress1) Thanks for the help!
That's great!
If so, please mark this question as solved. That will guide other users right in the future.
As above, the only change I would make is not to use the isnull function which is a bit sketchy at times!
if(len(Product_DESCR)<1,Code,Product_DESCR) as data