Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Functions of a calculated totals field
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01135308
Message ID:
01135314
Views:
11
Simple. You really need two report variables for this.

>Please consider the sample rpt layout below.
>
>The Route totals are at a group footing, totalling when group Route changes. So the values (in the 1st 2 totals: 370 and 400) are calculated, via Report Expression dialog, by the total fields being the same as the cursor fields: Trip1 and Trip2 (i.e their columns) and, via teh "Calculations" button -> Calculate Field dialog and "Sum" radio button selected.
>
>Trouble is, I need to do some maths on the 2 total fields, working out the percentage difference between them (in this example - 8%).
>
>So how do I refer to the calculated totals fields, in the %age field in order to produce its equation?
>
>I suppose there may be a similar problem in getting the tot of tots, e.g. Operator and Scheme totals but I haven't come to them yet.
>
>'ppreciate it
>
>Terry
>
>
>Operator Route Class No. 	No.
>		     Passengers	Passengers Multiplier Multiplier     Trips	  Trips
>A	 21	  14	    120		        1		            120	      0		
>		  15	    100		        2.5		   250	      0		
>		  40		      400		          1	     0	    400		
>    Route total						            370	    400	     8%	
>
>	 22	  14	    300		        1	   	            300	      0		
>		  40		      350	        1		              0	    350		
>    Route total							   300	    350	    17%	
>    Operator total							   670	    750	    12%	
>B	  1		- details ... -				   880	   1150	    31%
>
>	  2							   120	     50	   -58%	
>    Operator total						           1000	   1200	    20%	
>    Scheme total						           1670	   1950	    17%	
>
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform