Row Sum Function Does Not Work Correctly
Summary
Sum function on rows not accurateContent
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.
0