Joined: 24 Dec 2017
Location: United States
Online Status: Offline
Posts: 6
Topic: How to convert 0 to null value? Posted: 12 Feb 2018 at 6:41am
I am trying to display the 0 value as null. I don't want to suppress it because I'm using a background color for that entire row and don't want a white space (which appears if I suppress the value 0).
In the field formula I have the following code, but it's not doing any thing and would still display 0.
My field is NUM_DATA_02. @Blank is a formula with '' in it.
If {Command.NUM_DATA_02}=0 OR IsNull({Command.NUM_DATA_02}) Then val({@Blank}) Else {Command.NUM_DATA_02}
I even try the following code to specifically mention which record number, but that's not working either.
If RecordNumber = 7 and {Command.NUM_DATA_02}=0 OR IsNull({Command.NUM_DATA_02}) Then val({@Blank}) Else {Command.NUM_DATA_02}
Joined: 24 Dec 2017
Location: United States
Online Status: Offline
Posts: 6
Posted: 12 Feb 2018 at 7:36am
I have the following formula in "Display String" under common tab. This works but it changes my numeric field to text and I cannot format it with decimals and percent sign.
IF RecordNumber in [7, 14] Then ToText({@Blank}) Else ToText({@Numeric Data 02})
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged