UI only formula issue when field value is 0

  • 1
  • Problem
  • Updated 3 years ago
This formula leads to the UI field not populating (remaining blank) if either field value is 0. The referenced fields are Salesforce Formula fields. I have worked around this by adding an artificial 1 to each field to ensure a non zero answer, then subtracting them back out in the UI formula.
VALUE(((VALUE({{SCORE__c}}) + VALUE({{SCORE_2__c}}))/20)*100)
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Karen Waldschmitt

Karen Waldschmitt, Official Rep

  • 8,240 Points 5k badge 2x thumb
Hi Raymond~

I am trying to replicate the error you are experiencing. I have created a Ui-Only Formula field called New Score using the formula you included above where Score & Score 2 are Salesforce formula fields based off of number fields. Unfortunately, I am not encountering the same problem you are having as you can see below: 




One possible explanation is that my score & score 2 are based on number fields versus text fields that contain a number.  What type of fields are your score and score 2 fields based off of? 

Hope this helps!
Karen
Photo of Skuidward Tentacles (Raymond)

Skuidward Tentacles (Raymond), Champion

  • 17,224 Points 10k badge 2x thumb
They are Salesforce formula fields set to "if no value then zero". Thanks!