Hi,
Can you put together an array report example for me illustrating the
problem?
On Fri, 2006-02-17 at 21:28 +0100, michiel wrote:
> Hi,
>
> I tried calculating rowlevel percentages of a total of a break wich
> should show a result like:
>
> # %
> 3 75
> 1 25
> _
> 4
>
> using:
>
> <Variable name="sumnumber" value="val(q.number)" type="sum"
> resetonbreak="Maand" precalculate="yes"/>
> <Variable name="sumturnaround" value="val(q.turnaround)" type="sum"
> resetonbreak="Maand" precalculate="yes"/>
> <Variable name="perc_number" value="(val(q.numberl)/v.sumaantal)*100"
> type="expression" resetonbreak="Maand" />
> <Variable name="perc_turnaround"
> value="(val(q.turnaround)/v.sumturnaround)*100" type="expression"
> resetonbreak="Maand" />
>
> and showing them (q being the main query):
>
> <field value="q.aantal" width="10" align="right" col="3"/>
> <field value="val(q.turnaround)/100" width="10" align="right"
> format="'!# %.02f'" col="5"/>
> <field value="v.perc_number" width="10" align="right" format="'!#
> %.01f'" col="6" />
> <field value="v.perc_turnaround" width="10" align="right" format="'!#
> %.01f'" col="7" />
>
> But see percentages > 100%...
> As precalculate and delayed are not documented I'm kind of guessing and
> experimenting ;)
>
> Can this be done with RLIB and if so how should it be done..
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems? Stop! Download the new AJAX search engine that makes
> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users
|
