Eclipse Community Forums: BIRT » Averaging 2 columns using PERCENTSUM

Help

Home

Home » Archived » BIRT » Averaging 2 columns using PERCENTSUM(PERCENTSUM giving incorrect values)

Show: Today's Messages :: Show Polls :: Message Navigator

Averaging 2 columns using PERCENTSUM [message #1784384]

Tue, 27 March 2018 12:27

Kevin Blount

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 98 times)

Report message to a moderator

Previous Topic:	Count of Items By Date
Next Topic:	BIRT js files in Server Group

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 18:12:46 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter