Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #524

Re: Calculation with summary results ??

Show all headers | View raw

In article <voOdnaAlt8SGoZ_SnZ2dnUVZ_rOdnZ2d@westnet.com.au>, John G
<greentest@ozemail.com.au> wrote:

> When a summary result of several fields, in a table,with numbers, is 
> used in a subsequent calc the result is as expected. (Summary + x = 
> answer)
> If the summary is of a field that are all empty the result is OK the 
> summary is Zero and the calc returns the other value.(Summary + x = x)
> 
> If the summary is of a field where there are actually NO RECORDS, in 
> the table, then the result does not calculate at all even though the 
> other term has a value. (Summary + x = nothing )Just a blank field is 
> displayed
> 
> Is there an explanation or is that the way it is? :-?

I haven't got a version of FileMaker Pro in front of me, but there's an
option in the Define Calculation window to tell FileMaker what to do if
the source field(s) are empty - try turning that option on (or maybe it's
off, I can't recall which way around the option is worded).

The other option is to create this option yourself by checking for an
empty Summary field.
e.g.
      Calc    Calculation Field    Number Result
      = If (IsEmpty(Summary); X; Summary + X)

Helpful Harry   :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Calculation with summary results ?? John G <greentest@ozemail.com.au> - 2012-01-03 10:21 +1100
  Re: Calculation with summary results ?? HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-01-03 16:20 +1300
    Re: Calculation with summary results ?? John G <greentest@ozemail.com.au> - 2012-01-03 20:04 +1100
      Re: Calculation with summary results ?? HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-01-04 09:05 +1300

csiph-web