# Row Sum Function Does Not Work Correctly

22
Views
4
edited Apr 30, 2020 4:00PM 4 comments

# Summary

Sum function on rows not accurate

# Content

I am converting reports from FR to MR.  Several reports have row formulas using the Sum function.  It appears to not be working correctly, I have had to replace the Sum function with Addition function.

For example,

Line 12 A/P                  \$    3,319,835
Line 13 Accrued Liab         \$   53,025,386
Line 14 Deferred Rent        \$    4,300,040
Line 15 Facility             \$  314,900,000
Line 16 Notes                \$  175,000,000
Line 17 Securitization Notes \$4,323,630,949

Line 18 Total Liab           \$4,874,176,210

Row formula "Sum(Round([12],0),Round([13],0),Round([14],0),Round([15],0),Round([16],0),Round([17],0))-Round([18],0)" should have result of zero.  However, the result is (550,545,261).

Changing the formula to "(Round([12],0)+Round([13],0)+Round([14],0)+Round([15],0)+Round([16],0)+Round([17],0))-Round([18],0)" results in the correct answer of zero.