Replacing dash with empty in table

[jpjust]

All,

I have a simple table.

User              App      User Access last used NA               User Access Last used EMEA

User A          Test          03/21/2020                                                          -

User B         Test A             -                                                                      05/04/2021 

I want to fill the dash with blank. To achieve that I tried using the below expression in the app but did not take the effect.

=if(isnull([User Access Last Used NA]),'',timeStamp([User Access Last Used NA], 'DD/MM/YYYY'))

I tried some thing like this and did not work either.

=if([User Access Last Used]='-','',timeStamp([User Access Last Used], 'DD/MM/YYYY'))

Can some one please take a look and advice?

Thanks

[JuanGerardo]

Hi, you can convert those "dash" values to nulls, probably the best way to ignore those values in calculations:

NullAsValue [User Access Last Used NA];

Set NullValue = '-';

LOAD [User Access Last Used NA],

  other fields

from yourdatasource;

JG

[jpjust]

Thanks Juan for that idea. But unfortunately that did not work. 

Can't we do it in the chart level?

[JuanGerardo]

I thought you want to omit those values from your tables. In case you want to replace '-' (dash symbol) in your charts, you have to take into account it is used for nulls and missing values, so you will have to check both conditions, for example:

If(IsNull(EmptyIsNull([User Access Last Used NA])), '', [User Access Last Used NA])

JG