Multiplication formula
I need help multiplying two columns. One is a formula equaling a percentage, the other is the value of another column that is adding multiple columns together. I keep getting in invalid value error.
Colum  Probability  with the percentage looks like this:
Column  Total Software TCV  with the value that needs to be multiplied against the percentage looks like this:
Column  Weighted TCV (Software TCV * Probability)  that I keep getting the Invalid Value Error:
Any ideas what I am missing?
Best Answer

Hi @Stacy Stoffel,
In your Colum  Probability column, I notice you're using "25%" when assigning a value if the logical condition is True. Try removing the "" around the 25%.
You can instead assign either 25% or .25 in it's place. Do this for each percentage you're trying to assign in that formula.
Then a simple =[Probability %]@row * [Software TCV]@row
should work for you in your Column  Weighted TCV (Software TCV * Probability) column.
If wrapped with the VALUE formula, my testing resulted in the same. If that's the case, stick with the simpler formula above.
=VALUE([Probability %]@row) * [Software TCV]@row
Hope this helps!
BRgds,
Ray
Answers

Hi @Stacy Stoffel,
In your Colum  Probability column, I notice you're using "25%" when assigning a value if the logical condition is True. Try removing the "" around the 25%.
You can instead assign either 25% or .25 in it's place. Do this for each percentage you're trying to assign in that formula.
Then a simple =[Probability %]@row * [Software TCV]@row
should work for you in your Column  Weighted TCV (Software TCV * Probability) column.
If wrapped with the VALUE formula, my testing resulted in the same. If that's the case, stick with the simpler formula above.
=VALUE([Probability %]@row) * [Software TCV]@row
Hope this helps!
BRgds,
Ray

Thanks Ray! Changing all the values to decimal points did the trick. I really appreciate your assistance with this!

HI @Stacy Stoffel,
No problem, happy to help. Glad it worked!
Help Article Resources
Categories
Check out the Formula Handbook template!