Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Row Sum Function Does Not Work Correctly — Cloud Customer Connect
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
12
Views
4
Comments
edited Apr 30, 2020 4:00PM in Narrative Reporting 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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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