Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Averaging 2 columns using PERCENTSUM(PERCENTSUM giving incorrect values)
Averaging 2 columns using PERCENTSUM [message #1784384] Tue, 27 March 2018 12:27
Kevin Blount is currently offline Kevin BlountFriend
Messages: 4
Registered: March 2018
Junior Member
I am using the aggregation builder and the PERCENTSUM function to take the value in column B and divide it by column A to get the percent value for column C. The problem is that the value being returned is incorrect, about 55% higher than it should be.

ColumnA -ColumnB- ColumnC (result column: B/A) -Actual value
169495 - 965 - 0.74 - 0.41
161605 - 2994 - 3.36 - 1.85
183819 - 1482 - 1.46 - 0.81

(The dashes are spacers not math functions.) The actual value is done with a calculator. Both column A and column B are aggregations from SQL, building column C there would be very difficult.

I am using BirtMath.safeDivide to replace NaN values with 0.00, but if I turn off BirtMath the same thing occurs. The actual expression from the Aggregation Builder is in the attached screenshot.
  • Attachment: Capture.JPG
    (Size: 24.94KB, Downloaded 28 times)
Previous Topic:Count of Items By Date
Next Topic:BIRT js files in Server Group
Goto Forum:

Current Time: Sat Jan 18 19:42:09 GMT 2020

Powered by FUDForum. Page generated in 0.01769 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top