You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Row Sum Function Does Not Work Correctly

Received Response
edited Apr 30, 2020 4:00PM in Narrative Reporting 4 comments


Sum function on rows not accurate


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.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!