'=if( [LAND_COST_TDS_SGD]=0,[PART_NO_]) unable to filter missing value

[#1]

'=if( [LAND_COST_TDS_SGD]=0,[PART_NO_]) unable to filter missing value

Hi All

I have a table with missing value i try to filter these missing value , it does not work.

meaning i only wanted to list those value is missing or null. those with value don't want to display.

Try below , unable to work :-

=if( [LAND_COST_TDS_SGD]=0,[PART_NO_])

Hope some one can advise me.

Paul

[tresesco · Accepted solution]

PFA

[#3]

Try This

If(Len(Trim(LAND_COST_TDS_SGD))=0,PART_NO_,LAND_COST_TDS_SGD)

[#4]

Hi Paul,

you need to reconstruct your expression as

=if( IsNull([LAND_COST_TDS_SGD]),[PART_NO_])

Regards,

Rajesh

[#5]

Hi Sud

Thank you for your help in offer alternative solution , i choose the shorter one from other post.

Paul