### Title

Posting the calculation between two fields based on a condition?

### Post

I am new to FM (coming from flat file version 2) and tried to find an answer without success. I might be looking at the wrong places or It is just a very basic thing I overlooked.

When I normally want to get the result of a calculation, I create a Calculation field, which gets data from other fields and have the answer displayed in that field.

I am having a situation where I want to have a calculation and based on a condition I want to display them in 2 different fields. In this case I can not have the calculation in both fields.

Here is the simplified situation.

1. A field with number.

2. I want to multiply that number by 5.

3. I have two fields to display the results. One field is if the result is less than 50, other is more than fifty.

How do I do get the data posted in two separate fields, based on this condition?

George

Filemaker Case Statement http://www.filemaker.com/help/html/func_ref3.33.2.html

FieldOne is a Calculation with Number Result if FieldWithNumber times 5 is less than 50 Is FieldWithNumber times 5 - if more, empty

Case(field with number * 5 < 50; field with number * 5;"")

FieldTwo is a Calculation with Number Result if FieldWithNumber times 5 is more than 50 Is FieldWithNumber times 5 - if less, empty

Case(field with number * 5 > 50; field with number * 5;"")