Formula not working / just creates an error

[Jason_Nash]

{Business User Value} + {Time Criticality} +{Risk Reduction - Opportunity Enablement} / {Story Point Estimate}

The first part works great then I add the / and error
its nothing to do with the format of the fields as {Story Point Estimate} + {Business User Value} works fine… any ideas? its seem really odd to me

[Jeremy_Oglesby]

What’s the error you’re getting?

Did you try wrapping the numerator in parentheses?

[Kamille_Parks]

Are you dividing by zero?

[Jason_Nash]

Nope story point numbers which are selectable items the odd thing is that I can add them and - them away I can / them? it look like a bug to me personally

[Kamille_Parks]

Can you post a screenshot showing all relevant fields/sample values?

[Justin_Barrett]

And the error. @Jeremy_Oglesby asked about that above, and that might also provide clues.

[Jason_Nash]

This is why I think its a real bug this works {Business User Value} + {Time Criticality} +{Risk Reduction - Opportunity Enablement} + {Story Point Estimate}

This however does not
{Business User Value} + {Time Criticality} +{Risk Reduction - Opportunity Enablement} / {Story Point Estimate}

And Neither does
({Business User Value} + {Time Criticality} +{Risk Reduction - Opportunity Enablement}) / {Story Point Estimate}

And Tried
({Business User Value} + {Time Criticality} +{Risk Reduction - Opportunity Enablement}) / ({Story Point Estimate})
Just in case also still #ERROR!

[Jason_Nash]

Yep tired that… The Error is #ERROR!

[Jeremy_Oglesby]

Sounds like it could be related to the field type of one of your fields. Is one of your fields in the formula a Lookup or other non-number field?

[Jason_Nash]

Nope and if that was the case why would Adding them all work but dividing does not? They are all single select numbers FYI

This works
{Business User Value} + {Time Criticality} + {Risk Reduction - Opportunity Enablement} + {Story Point Estimate}