Problem with summing across groups [message #57584] |
Wed, 13 July 2005 14:01 ![Go to next message Go to next message](theme/Solstice/images/down.png) |
Eclipse User![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=) |
|
|
|
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 13:20 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) |
Michael McRoberts![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=mmcroberts%40spss.com) Messages: 9 Registered: July 2009 |
Junior Member |
|
|
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
>
|
|
|
Powered by
FUDForum. Page generated in 0.03343 seconds