Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Functions of a calculated totals field
Message
From
11/07/2006 10:15:27
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01135308
Message ID:
01135322
Views:
11
Thank you, bless you but what do I put in the var's? Sure they need to refer to the group total field but how do I refer to a field that hasn't a name but is the sum() of a group column.

>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%	
>>
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform