Skip to main content
Henry.Ong
Henry.Ong
Inspiring
February 28, 2023
Answered

How to display blank on computed field instead of zero?

  • February 28, 2023
  • 1 reply
  • 6791 views

Good day!

 

I have a computed field that I made "Read Only" because the value that will be displayed in this field should show the result of a mathematical formula. Currently, when you open the PDF file, what it displayed is $0.00 even if I have not inputted anything on the two operants.

 

Example:

 

F01001b = blank (no value entered yet)

F01001c = blank (no value entered yet)

F01001d = computed field with formula F01001b*F01001c

 

I wish that field F01001d should display blank and not $0.00 when no value is entered in F01001b and F01001c.

 

Thank you again for your effort in coming up with a solution to this request.

 

 

 

This topic has been closed for replies.
Correct answer Nesa Nurani

As validation script of that field, use this:

if(event.value == 0)event.value = "";

1 reply

Nesa Nurani
Community Expert
Nesa NuraniCommunity ExpertCorrect answer
Community Expert
February 28, 2023

As validation script of that field, use this:

if(event.value == 0)event.value = "";

    Henry.Ong
    Henry.OngAuthor
    Inspiring
    March 1, 2023

    Hi Nesa,

     

    Thank you for always being there to help me with my issue. Very much appreciated.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices