Groups > comp.databases.filemaker > #1580

Re: Help with flagging a total that is over/under 100 percent

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!weretis.net!feeder4.news.weretis.net!rt.uk.eu.org!aioe.org!.POSTED!not-for-mail
From	Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups	comp.databases.filemaker
Subject	Re: Help with flagging a total that is over/under 100 percent
Date	Sun, 15 Dec 2013 15:17:44 +1300
Organization	Aioe.org NNTP Server
Lines	60
Message-ID	<151220131517449110%HelpfulHarry@BusyWorking.com> (permalink)
References	<34111803-9d53-41a8-b501-4672b41f474e@googlegroups.com>
NNTP-Posting-Host	kkzcgqsTSYYysqFZuD3Udw.user.speranza.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	8bit
X-Complaints-To	abuse@aioe.org
User-Agent	Thoth/1.5.4 (Carbon/OS X)
X-Notice	Filtered by postfilter v. 0.8.2
Xref	csiph.com comp.databases.filemaker:1580

Show key headers only | View raw

In article <34111803-9d53-41a8-b501-4672b41f474e@googlegroups.com>, Tom
E <tevanoff65@gmail.com> wrote:

> I have a calc field that sums a few percent fields - I would like to flag the
> field if its under 100% or over 100% - when tabbed to the next field.
> 
> The flag could be a Popup Box with a alert?  suggestions?   
> 
> Sum
> (ProJPercent1;ProJPercent2;ProJPercent3;ProJPercent4;ProJPercent5;AdminPercent
> 1;AdminPercent2;CompProjPercent1;CompProjPercent2 )
> 
> Any help would be greatly appreciated! 
> 
> Thanks,
> Tom 

The simplest option is to have a Calculation Field that displays a
message if the toal is not 100 (and remains empty if it is 100).
e.g.
      Not100     Calculation, Text Result, Unstored
         = if (Sum(ProJPercent1; ProJPercent2; ProJPercent3;
                   ProJPercent4; ProJPercent5; AdminPercent1;
                   AdminPercent2; CompProjPercent1; 
                   CompProjPercent2) <> 100; "ERROR"; "")

Put the Not100 field on the layout in an appropriate place (perhaps
next to the Total field) and format it to display large and a bright
colour.

If you want to get fancy, you can use a Calculation Field with a
Container Result instead, which copies a graphic image from a Global
Field to display as the error message - a large red "Stop" sigh, a red
border around / behind the Total field, etc.

Or, as Christopher said, using the Conditional Formatting in newer
versions of FileMaker to achieve a similar highlighting effect.

In newer versions of FileMaker, you may be able to use a normal Number
Field with an unstored Auto-enter by Calculation, and then use the
Verification options to have a pop-up error window if the Field is not
equal to 100.

Two side-notes:

1.  You probably don't need to use the Sum function. The normal 
    addition operator (+) will work just as well.
    i.e.
         ProJPercent1 + ProJPercent2 + ProJPercent3 +
          ProJPercent4 + ProJPercent5 + AdminPercent1 +
          AdminPercent2 + CompProjPercent1 + CompProjPercent2

2.  Depending on where those percentage values are coming from
    and any rounding / truncating being done, it may not 
    actually be possible to always get a total of 100%.

Helpful Harry  :o)

Thread

Help with flagging a total that is over/under 100 percent Tom E <tevanoff65@gmail.com> - 2013-12-13 11:04 -0800
  Re: Help with flagging a total that is over/under 100 percent clkaufmann@gmx.ch (Christoph Kaufmann) - 2013-12-14 11:17 +0100
  Re: Help with flagging a total that is over/under 100 percent Helpful Harry <HelpfulHarry@BusyWorking.com> - 2013-12-15 15:17 +1300
  Re: Help with flagging a total that is over/under 100 percent Tom E <tevanoff65@gmail.com> - 2013-12-16 12:39 -0800
  Re: Help with flagging a total that is over/under 100 percent Tom E <tevanoff65@gmail.com> - 2013-12-16 12:43 -0800

csiph-web