General Questions
Elen Kuklina
Elen Kuklina

'List of numberfield' error in DIVIDE formula

Hey guys.

I need some help with my formula since I'm getting an error of unknown nature and I'm not sure whether it's a bad setting of my formula or a bug.

My initial request is to calculate % of story points spent on bugfixing from the total estimate of a user story.

Setup is the following:

  • Two separate tables - Stories and Sub-tasks - are linked via a Linked Record field.

  • Sub-tasks table has a Sub-Items field with the Estimate and Bugfix Estimate fields in it.

    • Estimate is a Single Select field with numeric values added in the settings.

    • Bugfix Estimate has the following formula:

      • SUM(NUMERICVALUE([Reported Bugs].[Estimate]))

  • In Stories I want to calculate the % of story points spent on bugfixing from the total estimate of a user story.

    • For this, I have a formula field set as following:

      • [Link to Sub-tasks].[Bugfix Estimate]/[Estimate]*100

    • This formula returns an error:

  • I tried to make the same formula with Bugfix Estimate set as a Number field but get the same error.

My question whether it's a bug or incorrect setting from my side?

Formulas
1
4 replies