Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

SUM Formula - Not Totaling Values with Decimals

Topic Labels: Formulas
927 3
cancel
Showing results for 
Search instead for 
Did you mean: 
ahigginbotham
4 - Data Explorer
4 - Data Explorer

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].

3 Replies 3
ahigginbotham
4 - Data Explorer
4 - Data Explorer

Current Formula that Does NOT Return Decimal Places as Desired

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

Alexey_Gusev_0-1727994704107.png

 




Alexey_Gusev
13 - Mars
13 - Mars

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