Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Problem with percentage calculation(Newbie with stupid question)
Problem with percentage calculation [message #1783157] Thu, 08 March 2018 15:30 Go to next message
Stuart Anderson is currently offline Stuart AndersonFriend
Messages: 3
Registered: March 2018
Junior Member
Hi All,

I am a newbie here so please be gentle with me ;-)

I have a report that groups by a complaint category. I have added an aggregation on the group to return the number of complaints in the category and also a total sum in the footer of the table. This all works ok.

I have attempted to add another aggregation of type PERCENTSUM using row["Agg1"] / row["Agg7"] * 100

Agg1 is the sum of my complaints grouped by category and Agg7 is the sum total of complaints, so the above logic would be 2 complaints in group / 1114 complaints * 100 should return 0.1795%.

The expression that I have used returns 100% for each group. I am highly likely to be doing something extremely simple wrong but at this stage I am tearing what little of my hair is left out.
Re: Problem with percentage calculation [message #1783194 is a reply to message #1783157] Fri, 09 March 2018 01:54 Go to previous messageGo to next message
Nitin Dahyabhai is currently offline Nitin DahyabhaiFriend
Messages: 4430
Registered: July 2009
Senior Member

Is this related to Eclipse somehow? I don't see a mention of the eclipse.org project to which this is related.

_
Nitin Dahyabhai
Eclipse Web Tools Platform
Re: Problem with percentage calculation [message #1783207 is a reply to message #1783194] Fri, 09 March 2018 08:33 Go to previous messageGo to next message
Stuart Anderson is currently offline Stuart AndersonFriend
Messages: 3
Registered: March 2018
Junior Member
Hi, sorry!!

I should have said that this issue relates to a report written in the Eclipse IDE for Java and Report Developers, Version: Neon.3 Release (4.6.3)

Re: Problem with percentage calculation [message #1819235 is a reply to message #1783157] Fri, 10 January 2020 10:40 Go to previous message
smk  developer is currently offline smk developerFriend
Messages: 1
Registered: January 2020
Junior Member
Basically Percentage Calculation Formula is,

Answer = (percent value /100)* Number

Use Online - W3PercentageCalculator.com
Percentage Calculator is free online accurate percentage calculator...


For Example,
What is 20% of 250?
Answer = (20/100)*250
Answer= 50


Previous Topic:Birt 4.7/4.8 throw warnings with Java 9/10
Next Topic:missing birt osgi runtime feature on the 2019-12 update site
Goto Forum:
  


Current Time: Fri Mar 29 01:56:27 GMT 2024

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

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

Back to the top