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?