Why is my =SUM formula calculating incorrectly?

Zach_

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.

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.

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.

Georgie

Hey @Zach_,

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

Georgie