1 Reply Latest reply on Feb 27, 2012 8:47 PM by davidanders

    Posting the calculation between two fields based on a condition?

    GeorgeRajendram

      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