Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Using report total in calculation Post Reply Post New Topic
Author Message
developer
Newbie
Newbie
Avatar

Joined: 04 Dec 2009
Location: Canada
Online Status: Offline
Posts: 6
Quote developer Replybullet Topic: Using report total in calculation
    Posted: 16 Dec 2009 at 8:24am
Hi all,
I'm trying to use the report total of a calculated field(Qty * price) to find its
percentage.
Here's an example, I'm looking for a solution to get the percent values in red.
 
                                                    % formula -> (qty * price)
                       (Qty * price)                               / report total of Qty * price 
   eg row 1      $261,508.84           15% -> (261,508.84 / 1,657,473.26)
        row 2      $189,183.97           11% -> (189,183.97 / 1,657,473.26)
        row 3              .                        .
        row 4              .                        .
report total   $1,657,473.26
 
Thanks
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Dec 2009 at 8:57am
Create one formula to get the row total(qty* price)
Call it 'RowAmount':
table.Qty * Table.price
Create another formula to get your % per row.
Report total = SUM({@rowAmount})
 


Edited by DBlank - 16 Dec 2009 at 8:57am
IP IP Logged
developer
Newbie
Newbie
Avatar

Joined: 04 Dec 2009
Location: Canada
Online Status: Offline
Posts: 6
Quote developer Replybullet Posted: 16 Dec 2009 at 11:29am
Hi Dblank,
When I try to save the percent formula that you suggested, I get a "The summary/running total field could not be created" error.
 
I'm not sure if this is related to the version.I am using ver 8.0.
Soon to be upgraded to XI
 
Thanks
 
IP IP Logged
developer
Newbie
Newbie
Avatar

Joined: 04 Dec 2009
Location: Canada
Online Status: Offline
Posts: 6
Quote developer Replybullet Posted: 16 Dec 2009 at 11:37am
One other thing, my qty comes from the table but my price comes from a subreport that gets the latest price. I do this  because some of the same item #'s on different transactions don't always have a price therefore I force a price on the ones that are at $0.00.
 
That might be why I'm getting that error.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Dec 2009 at 11:40am
Yes. The subreport issue would break this formula.
Is there another way to force a price without using a subreport?
IP IP Logged
developer
Newbie
Newbie
Avatar

Joined: 04 Dec 2009
Location: Canada
Online Status: Offline
Posts: 6
Quote developer Replybullet Posted: 16 Dec 2009 at 11:49am
I don't think so, because my subreport has to go find the price from another transaction of the same item #.
 
If my main report was sorted by item #, then I could easily use the price from a previous transaction by placing the price in a variable & using it based on the price being 0.00 or not.
 
Thanks anyway, I'll have to think of something else.
 
P.s. Too bad Crystal doesn't allow a subreport to run within a subreport, then I could run the whole report as a subreport in the report header to get my report total & use that value in my main report for the % calculation.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Dec 2009 at 12:05pm

Can you make a SQL view or a crystal command to get a 'master price list table' for each item # then join  that into your table and use it in the calculation instead?

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.