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.
Oct 03, 2024 11:44 AM
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].
Oct 03, 2024 11:45 AM
Oct 03, 2024 03:32 PM - edited Oct 04, 2024 06:39 AM
Hi,
solution is here (I think there is nothing to add):
Oct 04, 2024 06:38 AM - edited Oct 04, 2024 06:42 AM
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