Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #525

Re: Calculation with summary results ??

Show all headers | View raw

Helpful Harry submitted this idea :
> 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)

Thanks Harry,
I think I have tried every combination of the IF EMPTY check box but I 
could have got it wrong.

I had thought of doing some check and you have saved me the trouble. 
Your IF statement looks like the answer but I  have not had time to 
test it yet.

I should have said I am using FM P 11

-- 
John G.

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