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

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, 200520 yr by Guest
For got the Storage part

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

Yes all fields are numbers and storing is turned off

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.

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, 200520 yr by Guest

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.