Percentage of total

rbuser

I'm missing the point, can't find it and i know i did it once.

I want tot calculate the percentage/rate of a value in a detail line
compared to the total of the same field in a group footer

Example

Item 1 Sold 15,000 Rating would be 100/60,000*15,000 = 25.00 %
Item 2 Sold 35,000 Rating would be 100/60,000*35,000 = 58,30 %
Item 3 Sold 10,000 Rating would be 100/60,000*10,000 = 16,70 %
Total Sold 60,000

when i refence the value of the DBCalc i'm not getting the right total, not
even with lookahead on

Thx

digitalmetaphors

Here is an example Delphi project which runs a report with this calculation:

http://www.digital-metaphors.com/tips/PercentageOfGroupTotal.zip

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thx, but until now i can't download the example, it result in a page not
found.

digitalmetaphors

Yes, I am dealing with server issues, so that the web server will let me ftp
the tip. It was posted on our old server, but it didn't make it to the new
one:) Thankyou for your patience. I'm gonna email the example it to you.

--
Cheers,

Jim Bennett
Digital Metaphors

digitalmetaphors

I've emailed it to you also.

--
Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim

ftp
new

I am struggling withe same problem and would appreciate an email too.

Regards

John Hay

rbuser

Could you e-mail it to me as well as I have a similiar issue.

Thanks,

Scott Rowat
srowat@nextgen.on.ca

rbuser

Jim,

Have been out for a few days, thx for the solution, I implemented it and it
works fine.

But, dou you think this could be done in RAP. I'm trying as much as pissible
to do everything in RAP so that my reports (that are stored in a central DB)
can easily be distributed if anythign changes.

Cheers

digitalmetaphors

Yes, it should work the same in RAP. You'll have to port the code over to
RAP. Use global variables a TList. Leverage the global OnCreate and
OnDestroy events on RAP.


Cheers,

Jim Bennett
Digital Metaphors