Posting the calculation between two fields based on a condition?
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;"")