Groups > comp.databases.filemaker > #525

Re: Calculation with summary results ??

NNTP-Posting-Date	Tue, 03 Jan 2012 03:05:15 -0600
Subject	Re: Calculation with summary results ??
From	John G <greentest@ozemail.com.au>
References	<voOdnaAlt8SGoZ_SnZ2dnUVZ_rOdnZ2d@westnet.com.au> <HelpfulHarry-0301121620500001@203-118-187-182.dsl.dyn.ihug.co.nz>
Newsgroups	comp.databases.filemaker
X-Newsreader	MesNews/1.08.03.00-gb
Date	Tue, 03 Jan 2012 20:04:43 +1100
MIME-Version	1.0
X-ICQ	543516788
Content-Type	text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding	8bit
Message-ID	<LOCdnQPWeM5WWZ_SnZ2dnUVZ_sWdnZ2d@westnet.com.au> (permalink)
Lines	44
X-Usenet-Provider	http://www.giganews.com
NNTP-Posting-Host	124.149.125.28
X-Trace	sv3-2oj+1k9Pr+CsI5t0DLBtI4Ahj5YQT2q3U1LUBe8HLBj3ntt1Slnfs+sgDqauNiZYV4HGUDWMrg4n4CD!9tAYp6IAxHwcyU7/BBxa3QU4lX0eOMXhtTkeZQNVHkf1GxiW60Usmi8sV6xW9PUTTxnLBsVzxMb7!rfmYr4qvFYU7++tEOKzaXg==
X-Complaints-To	abuse@westnet.com.au
X-Abuse-and-DMCA-Info	Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info	Otherwise we will be unable to process your complaint properly
X-Postfilter	1.3.40
X-Original-Bytes	2810
Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.franciliens.net!feed.ac-versailles.fr!proxad.net!feeder1-2.proxad.net!74.125.46.80.MISMATCH!postnews.google.com!news1.google.com!Xl.tags.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local2.nntp.dca.giganews.com!nntp.westnet.com.au!news.westnet.com.au.POSTED!not-for-mail
Xref	x330-a1.tempe.blueboxinc.net comp.databases.filemaker:525

Show key headers only | 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