Brooklyn Q2: invalid syntax for field formula

  • 1
  • Problem
  • Updated 10 months ago
  • Solved
Just updated from 9.5 to 10.0.13

Now I'm getting these two syntax errors on formula fields:

1. Invalid syntax for field formula: ROUND({{{appointments}}} / ({{{scheduleRate}}} * {{{showRate}}})) . SyntaxError: Expected "(" or [ \x0C\n\r\t\x0B  ᠎ - 

 ] but "*" found.
2. Invalid syntax for field formula: ROUND({{{vulnerableCallers}}}*{{{$Model.AgCompleteInitialPregAppointments.data.0.scheduleRate}}}). SyntaxError: Expected "(", ".", [ \x0C\n\r\t\x0B  ᠎ - 

 ], [a-z0-9_], or [a-z] but ")" found.


I made the formulas bold to make them easier to see.

Seems like there might be a problem with multiplication inside ROUND()?
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb

Posted 10 months ago

  • 1
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
It wasn't ROUND().

If I put VALUE() around {{{scheduleRate}}} the error is eliminated (despite the fact that scheduleRate is set to return a Number). 
Photo of Matt Sones

Matt Sones, Champion

  • 31,478 Points 20k badge 2x thumb
Hi team! I noticed this was marked solved (which is fine, since I do have a solution), but is there a bug here?
Shouldn't a ui-only field returning a number be able to be used as a number in another formula without requiring VALUE() around it?