Percentage Formula

Hargreaves
Hargreaves ✭✭
edited 09/20/22 in Formulas and Functions

I am trying to obtain the percentage of the following:

Orders On Time

Orders In Full

Orders On Time in Full

My formulas are as follows:

Orders On Time - =ROUND(SUM([On Time (OT) %]1 / [Order Count]1)) + "%"

Orders In Full - =ROUND(SUM([In Full (OTIF) %]1 / [Order Count]1)) + "%"

Orders On Time in Full - =ROUND(SUM([On Time (OT) %]1 - 0 / [On Time (OT) %]1 + [Late %]1)) + "%"

Basically my Order On Time is not working and only showing 0% but removing the round gives a value of 21%

I enclose a screenshot of my test data

The figures to the right of the results is formula with out the round added for example

=SUM([On Time (OT) %]1 / [Order Count]1)

If my formulas \ maths are incorrect please advise as i would like to get this sorted.

Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!