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 = "";

    Tammy28781641mkxk
    Tammy28781641mkxk
    Participating Frequently
    March 9, 2023

    This did not work for me. It actually produced a 0 once the calculation was run?

    Nesa Nurani
    Community Expert
    Nesa NuraniCommunity Expert
    Community Expert
    March 10, 2023

    That did not work either 😞 Sigh...


    Where did you put the script?

    Did you check that field names are correct?

    Share your file, so we can see what is going on.

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