Re: Calculation Field Comparing Calculation Fields?
- From: Helpful Harry <helpful_harry@xxxxxxxxxxxxxxxx>
- Date: Wed, 29 Mar 2006 08:52:29 +1200
In article <442980d3$0$29669$636a55ce@xxxxxxxxxxxx>, "Remi-Noel
Menegaux" <rnmenegaux@xxxxxxx> wrote:
"Eric" <nospam@xxxxxx> a écrit dans le message de news:
442977F2.11E02F04@xxxxxxxxx
Either FMP8 does not allow a Calculation Field to compare to another
Calculation Field, or perhaps there is a nifty trick to do so?
I've tried 'IF' and 'CASE' functions to no avail.
Field 1 = TextA
Field 2 = TextB
Field 3 = Text C (This is actully TextA + TextB from another source)
Field 4 = (Calculation Field)...I am trying to make this a "Flag"
notification field to display "DIFF" (text) if: TextA & " " & TextB are
NOT equal to Text C.
Am I out of luck?
You may try :
Field 4 = Case((Field 1 & " " & Field 2) <> Field 3, "DIFF"; "FLAG")
I don't see why it shouldn't work...
I suggest you show on the same layout Field 1, Field 2, Field 3 and Field 4,
just for checking.
My first guess would be that Eric doesn't have any brackets on his test.
The test
Field 1 & " " & Field 2 <> Field 3
could be a completely different one to
(Field 1 & " " & Field 2) <> Field 3
I'm not sure what the precedence order is here, so the first test could
actually be being calculated as
Field 1 & " " & (Field 2 <> Field 3)
which is not what you want.
It's always best to put the brackets in to make sure the calculation is
performed the way you want. As with all mathematics, the brackets (or
parentheses if you prefer) are EXTREMELY important - not having them or
having them in the wrong place can cause all sorts of strange results,
and is a very simple thing that we all get wrong from time to time.
A second guess would be an incorrect field - maybe a local field is
being used instead of a related one somewhere along the line, or
perhaps it is the correct related field, but via the wrong
relationship.
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
.
- References:
- Calculation Field Comparing Calculation Fields?
- From: Eric
- Re: Calculation Field Comparing Calculation Fields?
- From: Remi-Noel Menegaux
- Calculation Field Comparing Calculation Fields?
- Prev by Date: Relationship AND OR
- Next by Date: Re: Resizing multiple windows
- Previous by thread: Re: Calculation Field Comparing Calculation Fields?
- Next by thread: Relationship AND OR
- Index(es):
Relevant Pages
|
Loading
