AnsweredAssumed Answered

Calculated value based on a condition

Question asked by kwinnett on May 2, 2016
Latest reply on May 3, 2016 by emha

I am working on a pay change form.  I need to calculate a value based on a condition.  Here are my fields

 

Current pay rate=currency type

type of adjustment=choice column with choice of increase or decrease

amount of adjustment=currency

adjusted pay rate=currency

 

If the user selects increase for "type of adjustment" then the amount of adjustment needs added to the current pay rate and the adjusted pay rate needs populated with that amount.

If the user selects decrease then the amount of adjustment needs subtracted from the current pay rate and the adjusted pay rate needs populated with that amount.  I did this in InfoPath at one point, but InfoPath has an "Action" rule available.

Outcomes