Functions convert to percent

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

How would I modify my formula to show the bold as a percent?

If([UOM]="LS",([TOTAL QTY COMPLETE]-[MTD QTY COMPLETED])/[TOTAL QTY SCHEDULED],[TOTAL QTY COMPLETE]-[MTD QTY COMPLETED])

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
Its a bit messy as you would need to make this result field to be a text formula field and create the text string.

If([UOM]="LS",

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

totext([TOTAL QTY COMPLETE]-[MTD QTY COMPLETED]))