Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1580

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

Show all headers | 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)

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

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