ui-only formula field does not add values from other ui-only formula fields

  • 1
  • Problem
  • Updated 1 year ago
  • Acknowledged
Here's my formula for a ui-only field called 'sum' which should return a number:

{{SchoolCareer}}+{{AgeUnder26}}+{{FinancialPressure}}

All three of those fields are also ui-only formula fields which return a number.

The three fields work, the sum field does not.... it just shows blank.

Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Wrapping VALUE() around each of the fields doesn't help.
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
This looks like a bug,  or a feature.  We'll decide and make it work.. 
Photo of Craig Rosenbaum

Craig Rosenbaum

  • 4,776 Points 4k badge 2x thumb
I just encountered an issue where I was trying to add a Ui only field (Field A) with a non-Ui field (Field B) into my Ui only fomula field (Field C). When I used the + expression, it was concatenating the numbers. All three fields are integers. VALUE was working, but not when one of the fields was blank. I noticed multiplication of field A and B together was working, so my workaround was to make Field C = (1 * Field B) + (1 * Field A)
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
We have been working on this aspect of formula fields and will be releasing that package early next week.   The nested formula fields issue is one of those things we have worked on. 
Photo of Matt Brown

Matt Brown, Employee

  • 798 Points 500 badge 2x thumb
Rob is this still a bug? The only way I was able to add numbers from UI-only formula fields inside another formula field was by multiplying them by 1 before adding them.
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Hey Skuid. Has this been resolved?