Filemaker GONE NUTS

[Sam5271]

I spent the last day trying to figure out a first grade math with a SIMPLE Calculation.

I have a table with a Number field reflecting high values. Let's call it "High" Then another field that is a Number value as well.

THen I am creating a Calculation that says if If (field 2 > than "High ;1 ;0).

JUst a simple first grade math.

Well the Crazy thing is like this.

Let's say High contains the # 55

Then Field 2 has a # 66

Based on this the result should be 1 right...

Well Not according to Filemaker.

it sometimes decides to consider the Value 500 or 600 not to be > than 55.

So it is randomly giving me 0, or 1 not according to the 1st grade math....But what it sound like a 5th Dimension Calculation and physics that is out of this world and that I can not understand.

This seems to be happening accross the board and even with linking tablets together.

Does this sound familiar to any one. WHat is going on.

Sam

[Lee Smith]

Your If statement gives me a 1.

If( field 2 :great: High; 1 )

or

Case( field 2 :great: High; 1 )

Are all fields numbers? Be sure you have turn off storing?

HTH

Lee :

Edited July 18, 2005 by Guest
For got the Storage part

[Søren Dyhr]

Even I would be confused by such a syntax:

> than "High

It's likely that the word High is in quotes - which have some bearings in the use of this function: Evaluate(

Pull down help, and read how this particular function handles things in quote ...and wonder why they've made the function in the first place??

Must I suggest that you handle references to fields without quotes, and operators inside the scope of thouse if you wish filemaker free of interpretation errors???

--sd

[Sam5271]

Yes all fields are numbers and storing is turned off

[Sam5271]

Hi and thanks.

No this was just a typo. This is exactly how I am doing it.

High is the name of field one. (Number FIeld).

Test is the name of field two. (Number FIeld).

Test_Calc is the name of field 3. (Number FIeld).

Test_Calc = If ( Test > High; 1; 0)

Just this simple, first grade math. Nothing more.

[Lee Smith]

Hi Sam,

First of all, be sure you are using 7.03.

As I said before, your calculation worked for me as you described it. [color:blue]In both v6 and v7.

In order for us to verify futher, you will need to Post a sample of your file.

Lee

:bigshades:

Edited July 18, 2005 by Guest

[comment]

Your formula should work. Test_Calc should be a calculation field, wih result set to number.

Note:

1. The same formula can be written more efficiently as Test_Calc =

Test > High

2. IMHO the calculation can be stored or unstored as you wish.