Basic Table - Column Styling Rules

[nihou]

I have set up a rule to replace all Null() with "N/A", but it still blank once I render and open the report.  Any suggestions?

[nihou]

I have set up a rule to replace all Null() with "N/A", but it still blank once I render and open the report.  Any suggestions?

[apathetichell]

Can you do this in a formula before the Table?

If it's a numeric format and the field has no negative values- I believe that you can use <=0 and get it to recognize as null().

[nihou]

@apathetichell it is a String, I do not want commas, I can send you a screenshot.

[apathetichell · Accepted solution]

Sure - but if it's a string just set it up however you want in formula beforehand.

You can use a blanket if isempty([field]) then "N/A" else replace([field],",",""). endif

the table formatting properties are great for numbers where you don't want to lose the ability to do numeric options with them. for strings - just pre-format.