Eclipse Community Forums: BIRT » Problem with summing across groups

Home

Home » Archived » BIRT » Problem with summing across groups

Problem with summing across groups [message #57584]

Wed, 13 July 2005 10:01

Eclipse User

Originally posted by: brad.donotemail.com

I am new to BIRT and have run into some trouble. I am working on a stock
portfolio report. Users have stocks from several sector in their
portfolio. Each stock has a market value. I have created a group on the
dataset by sector. In the group footer for each sector I want to display
what % that sector is of the total portfolio. I tried doing this:

Total.sum(row["mktval"],null,"Sector")/Total.sum(row["mktval "],null,Total.OVERALL)

It seems to display properly for the final group only. The page also
returns this error:

There are errors on the report page:Error1:Invalid Javascript expression.
Source: null, line: 0, Expression:Script engine error: This aggregate
expression is only available at the end of a group

How can I get this to display properly for all groups? I would appreciate
it if someone could point me in the right direction.

Thanks

- Brad

Re: Problem with summing across groups [message #58317 is a reply to message #57584]

Thu, 14 July 2005 09:20

Eclipse User

I tried this out and it appears there is a bug with
Total.sum(...,null,Total.OVERALL) being in a group footer. It does work
in a group header, so as a temporary workaround try putting your summary
in the group header.

I created the bug report #103802 to report this issue.

Brad wrote:
> I am new to BIRT and have run into some trouble. I am working on a stock
> portfolio report. Users have stocks from several sector in their
> portfolio. Each stock has a market value. I have created a group on the
> dataset by sector. In the group footer for each sector I want to display
> what % that sector is of the total portfolio. I tried doing this:
>
> Total.sum(row["mktval"],null,"Sector")/Total.sum(row["mktval "],null,Total.OVERALL)
>
>
> It seems to display properly for the final group only. The page also
> returns this error:
>
> There are errors on the report page:Error1:Invalid Javascript
> expression. Source: null, line: 0, Expression:Script engine error: This
> aggregate expression is only available at the end of a group
>
> How can I get this to display properly for all groups? I would
> appreciate it if someone could point me in the right direction.
>
> Thanks
>
> - Brad
>

Previous Topic:	Get Session Context through scriptin
Next Topic:	BIRT Installation Problem Unable To instantiate editor

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Mar 29 20:56:26 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter