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?

Find more posts tagged with

Formulas

Accepted answers

Ray Lindstrom

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

All comments

Ray Lindstrom

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

Stacy Stoffel

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

Ray Lindstrom

HI @Stacy Stoffel,

No problem, happy to help. Glad it worked!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.