Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Percentage Help please Post Reply Post New Topic
Author Message
robert
Newbie
Newbie
Avatar

Joined: 18 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 15
Quote robert Replybullet Topic: Percentage Help please
    Posted: 23 Nov 2009 at 1:18am
hi there
 
i am trying to do a percentage, usually a pretty simple thing yes.
 
i need a percentage of two other fields on my report, they are "sum of popdet.qty_order and sum of @recdontime.( @recdontime is another formaula field not doing anythign fancy)
 
So quanity ordered and quantity received on time, i need a percentage to show how much of the goods were received on time e.g qty ordered = 50 qty received on time = 25 so percentgae woul be 50%
 
any help greatly appreciated
 
IP IP Logged
robert
Newbie
Newbie
Avatar

Joined: 18 Nov 2009
Location: United Kingdom
Online Status: Offline
Posts: 15
Quote robert Replybullet Posted: 23 Nov 2009 at 1:56am
ok think i solved this, so here is my solution for anyone else who struggles with this. i just created two more formula fields. here is the formula field i dropped onto the report
 
 if Sum ({@recdontime}, {pophead.inv_account})/Count ({popdet.qty_order}, {pophead.inv_account})> 0 then Sum ({@recdontime}, {pophead.inv_account})/sum ({popdet.qty_order}, {pophead.inv_account})* 100 else 0
 
 
the formula for @recdontime is ....
If {plhist.rec_date} <= {popdet.date_due} then {plhist.qty_rec} else 0
 
 
and i think thats solved it (think)
 
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.