Skip to main content

SUM Formula - Not Totaling Values with Decimals

  • October 3, 2024
  • 3 replies
  • 29 views
A
Forum|alt.badge.img+2

I have four (4) columns that are number data fields titled {Trip 1 Miles}, {Trip 2 Miles}, {Trip 3 Miles}, and {Trip 4 Miles}. The settings to the number data fields include decimal places and a screenshot of the settings are attached.

Column five (5) is titled {Total Miles Traveled} which is a formula data field that SUMS the total of the number data fields listed above. 

THE PROBLEM TO SOLVE: I am unable to get the formula in {Total Miles Traveled} to include decimal points in the SUM total. A screenshot is attached. The formula is totaling [26.70 + 26.70 + 9.10 + 9.10] and is rounding the answer to [72] instead of the desired answer with decimal points as [71.60].

2 Attachments

3 replies

A
Forum|alt.badge.img+2
  • ahigginbotham
  • Author
  • New Participant
  • October 3, 2024

Current Formula that Does NOT Return Decimal Places as Desired

1 Attachments
Alexey_Gusev
Forum|alt.badge.img+25

Current Formula that Does NOT Return Decimal Places as Desired


Hi,
solution is here (I think there is nothing to add):

 




TheTimeSavingCo
Alexey_Gusev
Forum|alt.badge.img+25

no,

I think, this worth to be added, and maybe save time for somebody, 

you are using SUM in a strange way
SUM(A,B,C)  is the same(almost)  as  A+B+C
In your formula SUM(A+B+C) works just because SUM(X)=X

The difference is when any of fields is NaN
A+B+NaN=NaN
SUM(A,B,NaN)=SUM(A,B)
I suppose it works with #ERROR too, but i'm not sure

Terms & ConditionsAccessibility statement