AnsweredAssumed Answered

Posting the calculation between two fields based on a condition?

Question asked by GeorgeRajendram on Feb 27, 2012
Latest reply on Feb 27, 2012 by davidanders

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

 

Outcomes