Functions Limit the decimal from a number "ToText"

  • 0
  • 1
  • Question
  • Updated 5 years ago
  • Answered

How would I limit the number of decimal places on the below values....It I leave it as is, my % and numbers allow for several decimal places.

If([UOM]="LS",ToText(([TOTAL QTY COMPLETE]-[MTD QTY COMPLETED])/[TOTAL QTY SCHEDULED]*100)&"%",ToText([TOTAL QTY COMPLETE]-[MTD QTY COMPLETED]))

Thanks in advance!

Photo of Joshua

Joshua

  • 0 Points

Posted 5 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,760 Points 50k badge 2x thumb
If([UOM]="LS",

ToText((round([TOTAL QTY COMPLETE]-[MTD QTY COMPLETED])/[TOTAL QTY SCHEDULED]*100,0.1))&"%",

ToText(round([TOTAL QTY COMPLETE]-[MTD QTY COMPLETED]),0.1))




Hopefully that is correct syntax.

here is the round function help info https://www.quickbase.com/db/6ewwzuuj?a=dr&r=5&rl=j2x



in the example above I am showing 1 decimal place