Numeric formula field is replacing the number with a 0.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Hi All, I have a html formula-text field that is pulling in a few summary and formula-numeric fields. It shows up correctly here, but when exported out, these fields within the html display as 0. Any ideas why this could be occurring? Screenshots included of the raw html formula-text field, that correctly displays the numbers, as well as a screenshot of the exported field, and the mysteriously modified numbers. 
Photo of Ursula Ll

Ursula Ll

  • 1,678 Points 1k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Can you help me understand.  Are you exporting HTML and expecting to get just clean numbers exported?
Photo of Ursula Ll

Ursula Ll

  • 1,678 Points 1k badge 2x thumb
Hey There! I am exporting this field out and expect a table with the clean numbers. Unfortunately, it is exporting and correctly creating the table, but instead of the expected numbers seen in the formula-text field above, it is replacing them all with the number 0. I have attached an image of the actual html code placed into the formula field, which shows the fields displaying correctly in the view form in the html_field image above.
Photo of Ursula Ll

Ursula Ll

  • 1,678 Points 1k badge 2x thumb
Hey There! I am exporting this field out and expect a table with the clean numbers. Unfortunately, it is exporting and correctly creating the table, but instead of the expected numbers seen in the formula-text field above, it is replacing them all with the number 0. I have attached an image of the actual html code placed into the formula field, which shows the fields displaying correctly in the view form in the html_field image above.
if you are exporting html you cannot expect to get clean numbers exported.  You will need to have an alternate export report without the fancy formatting.
Photo of Ursula Ll

Ursula Ll

  • 1,678 Points 1k badge 2x thumb
Looks like the reason they were not being pulled in was because I hadn't given the document permission to view the table the fields were coming from. Once that permission was modified, my numbers showed!