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

Groups > comp.databases.filemaker > #831

Re: Quick Question - If Calculation funtion Syntax

Show all headers | View raw

On Mon, 21 May 2012 11:18:49 -0700 (PDT), JayBee wrote:
>  The reason why I was asking is because I'm trying to use an If
>  calculation function in calculation fields where result is text.  You
>  confirmed what I thought was true above, so I don't understand why it
>  is not working:
> 
>  My calculation is the following for each respective field: Field1:
>  If(ABorC1="A";PartsUsed1)
>   
>  Field2: If(ABorC2="A";PartsUsed2)
>   
>  Field3: If(If(ABorC3="A";PartsUsed3) etc etc up to field 17
> 
>  However at the moment even if one of fields with a pop up menu ABorC
>  is not equal to A but is actually equal to B or C the parts used field
>  is still the result whereas I'd actually want it to be blank if the
>  value is B or C and only show the value if it applies to A and A is
>  true for the relevant ABorC field.
> 
>  Can anyone think why this is?  I'm stumped so far!

A) does it rely on fields which may be empty? Did you tick the options
to compute on empty fields?

B) is it a calculation field with result text or an autoenter on a
simple text field? If text field, mark the option to replace field
contents with new results

C) is the one of the fields a related data? This may cause trouble
especially if the source is within another file. Data should be within
the same file, within another table.

D) is the data from a relation? Then calculation may be blocked until
the record is left.

E) is one of the fields for the calculation still active? Calculation
will happen only if the field was left.

Just some ideas...
Martin

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

Thread

Quick Question - If Calculation funtion Syntax JayBee <Jennifer_Beecroft@hotmail.com> - 2012-05-16 00:17 -0700
  Re: Quick Question - If Calculation funtion Syntax Martin Τrautmann <t-usenet@gmx.net> - 2012-05-16 08:57 +0000
    Re: Quick Question - If Calculation funtion Syntax JayBee <Jennifer_Beecroft@hotmail.com> - 2012-05-16 04:11 -0700
      Re: Quick Question - If Calculation funtion Syntax JayBee <Jennifer_Beecroft@hotmail.com> - 2012-05-21 11:18 -0700
        Re: Quick Question - If Calculation funtion Syntax Martin Τrautmann <t-usenet@gmx.net> - 2012-05-21 18:27 +0000
          Re: Quick Question - If Calculation funtion Syntax "Ursus" <Ursus.kirk@gmail.com> - 2012-05-21 22:39 +0200
        Re: Quick Question - If Calculation funtion Syntax HelpfulHarry@BusyWorking.com (Helpful Harry) - 2012-05-22 09:05 +1200
          Re: Quick Question - If Calculation funtion Syntax JayBee <Jennifer_Beecroft@hotmail.com> - 2012-06-10 02:53 -0700

csiph-web