Conference ilbbak::ibi_focus

29.0. "Complex reporting - help " by VICTOR::BARNES () Wed Feb 03 1988 06:59

	I am developing an application for financial reporting.
	It requires calculations to be carried out on the data 
	input , expense allocation ,consolidation of data and 
	production of forecasts in a spreadsheet type format.
	
	Is there anybody who has experience of using Focus for
	complex calculations and reporting who could offer some
	advice and assistance?

	It seems I will need to write some of my calculations to
	a Hold file and then use it to update my records.

	For example;

	In order to calculate the expense of manpower I need to 
		1) Calculate the Cost per Man value for each record.
		   These are compute fields as they need sums
		   of field values.
		   ie. Region 1 CPM1 ,Region 2 CPM2
		2) Use ALL of these calculated values against each record 
		   for a further calculation 
		   ie. Region 1 needs CPM1 and CPM2 ,Region 2 needs CPM2 and
		       CPM1

	Any advice or examples of existing applications would be very
	helpful.

						Pauline