issue on null sring in table box and straight table

[#1]

hi

i have requirement that in my dashboard i have value called 'Null' i need to convert into Empty space.how to make it .

i have to convert 'NUll' into Space in table box and stairght table

Note:Null is string not like null()

thanks

Siddiq

[santiago_respane · Accepted solution]

Hi Abubakar,

in your straight table you can use an expression lik this:

=IF(<YourField>='NULL',' ',<YourField>)

But if you want to change it on a table box object you must do it the loading script, maybe with a preceding load or something like that.

Maybe you can share your app in order to be more helpfull.

Hpe this helps.

Kind regards,

[#3]

Thanks Santiago Respane