Why is my =SUM formula calculating incorrectly?

Hi there.

I have a pretty simple formula that is incorrectly calculating the sum of four columns. Depending on how I construct the formula, I'm getting two different values, but both are incorrect. I can't figure out the issue.

=SUM formula:

=SUM([Score: Has Start Date]@row, [Score: Has Delivery Date]@row, [Score: In Progress + Actuals Within 12 Wdays]@row, [Score: In Progress + Status Within 2 Months]@row)

I also tried to use plus signs instead of commas, but that actually produces a value of 0, rather than 60.

Screenshot:

What have I done wrong? I don't understand why it will not sum to 100.

Find more posts tagged with

Accepted answers

Zach_

I figured this out myself. Apparently one of these values (probably the middle column in the screenshot, based on the score sum) was a text value rather than a number. Affixing the VALUE function to each reference in the =SUM formula fixed the issue.

All comments

Zach_

Georgie

Hey @Zach_,

Thanks for posting your solution. I'm glad you were able to work this out!

Georgie

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.