Creating a formula with a drop down box of percentages
I am working on using a drop down box to calculate task percentage as well as the complete percentage total per phase. Initially we were using the % Complete and allowing any percentage to be entered however now we are going with a set percentage to make it easier on the client. The problem is that now when I use the same formula it calculates 100 regardless of what the drop down box selection is.
The choices are in 25% increments. I am not sure what I am doing wrong. There are 38 tasks within Phase I and no matter what I change the drop down selection to the answer is always 100%.
25%*2 should be 50% or is my math off? Any feedback would be very helpful.
Help Article Resources
Check out the Formula Handbook template!