How to calculate formula when creating a new thing

[hisham]

The issue is really simple, I want to create risk-rating field using below formula:

1 - (Sum of risk-rating/ Sum of risk-rating-max)

But I could not filled the formula using the logic above. If you happen to know anything that I missed or workaround that could be used, I really appreciated it. I also attached screenshot of the backend workflow.

[grgrsmth]

To make the exact formula you’ve written out:

Arbitrary text:converted to number - (Sum of risk-rating / Sum of risk-rating-max)

then set the Arbitrary text to be 1

Alternatively, to write it without converting text to number:

( (Sum of risk-rating / Sum of risk-rating-max) / -1 ) + 1