### Title

Report Calculations

### Post

Is it possible to calculate a ratio or percentage of 2 fields in a sub summary report?

i have done the calculation and despite placing it in the sub summary it calculates it based on the total records rather than the ones in the sub summary.

please help before the computer flys!!!!!

andyg4137:

Well, if your denominator is zero, then you will definitely have problems! You could modify the calculation to:

If ( GetSummary ( summaryField 2 ; Consultant ) = 0 ; 0 ;

GetSummary ( summaryField 1 ; Consultant 0 / GetSummary ( summaryField 2 ; Consultant )

That is, check to see if the denominator is zero. If so, then report zero. Otherwise, perform the calculation.

TSGal

FileMaker, Inc.