Using Expression Box returns annoying "null" values for 0 keyfigures

[Former Member]

Hi,

In a table I am using an expression box to give certain keyfigures a certain format. (e.g. KF value lower then 0 means a red background).

All of this works fine but I have a nasty side effect. All keyfigures that don't have a value (0 or empty) now return the value 'null' in the table which is not really nice to show. When I didn't use a expression box but a normal input field it showed nothing or 0 which is fine.

I tried to supress this with the "Hidden" property on the Expression Box but this didn't do anything. Does anyone have a hint how I can get rid of this ? I use Expression Boxes quite a lot so I'd really love to get rid of these "null" values.

thanks

[Former Member · Accepted solution]

Hi Double,

in your expression box you have a default value, where you can use a formula.

Why don't you filter all the 'null' values? - E.g. If(ISNULL(@value),' ',@Value)

Best Regards,

Marcel

[Former Member · Accepted solution]

Great answer, great solution. Works fine !