Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Formulae for total Post Reply Post New Topic
Author Message
syedmca
Newbie
Newbie


Joined: 02 Apr 2008
Location: Uzbekistan
Online Status: Offline
Posts: 4
Quote syedmca Replybullet Topic: Formulae for total
    Posted: 24 Apr 2008 at 6:48am
How do I need to create a formula in Crystal Reports (CR) to get the TotForm HR
Totformhr= total processed*3600/timetaken

Kindly help me by guiding steps need to be taken to get  this formula in crystal reports.How many variables need to be created.How to do calc

Form_type TotalProcessed  Timetaken   TotForm HR
                          HH:MM:SS
AAAA         15             0:00:46     1173.91
BBBB         1              0:00:12     300.00
CCCC         169            0:18:26      550.09
--------------------------------------------------
             185            0:19:24    572.16


Thanks in advance
Syed
syed
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 24 Apr 2008 at 6:25pm
To create a new formula, look in the Field Explorer window and right-click on the Formulas node. Then select New and give it a name.This opens the Formula Workshop window. You can drag fields from the top window into the edit window below. This automatically enters the field name for you so that you have the correct syntax. It might look something lke:
{TableName.TotalProcessedField}*3600/{TableName.TimeTakenField};

Save your changes (checking for errors) and then we you go back into design mode you can drag and drop this formula onto your report to print it.

I have complete coverage of how to write formulas and use the Formula Workshop in Chapters 5-7 of my Encyclopedia book. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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.