formulas and zero

CC May 24, 2023

We are using WSJF to determine priorities.  Our scale is 0,3,8,13 for both business value and tech effort.  The formula is Business Value divided by Tech Effort.  Since we are using 0 for minimal tech effort, I have to figure out how to replace the 0 for 1 in the formula so the WSJF value is just the business value.

Anyone have a work around for this?  

2 answers

Suggest an answer

Log in or Sign up to answer
0 votes
CC May 25, 2023

1+ would be confusing given the simplicity of the formula.  Ideally it would be great if we expand the formula functionality to include if then statements and error handling.

0 votes
Beau Fruits May 24, 2023

I would just add 1 (or some value you feel comfortable with) to Tech Value, specifically in my formula.   

  • (bus value) / (1 + tech value)


(or I wouldn't allow 0 for the technical impact)...  personal opinion, but I'm not a fan of the tool fighting with the process, so something simplistic is my method of choice. 

Rohan Swami
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 25, 2023

I would go with this approach as well. If you also want to have a zero score then you could add 1 to the business value too.

AUG Leaders

Atlassian Community Events