I am tweaking an existing comparatio field to show the comparatio for the new payrate on a promotion/payrate change. It works beautifully based on a when value changed statement (see below):
PayRate
label is untranslatable:"NewPayRate"
when value changed
PercentIncrease = (PayRate / OriginalPayRate - 1)
NewPosition.CompaRatioPercentDisplay = (PayRate / NewPosition.Zone2PayZone)
Where it stops working beautifully is at the point of approval. When the approver brings up the form, the NewPosition.CompaRatioPercentDisplay has reverted to its empty state. What I would like to do is force a default/initial value on this field so that it ALWAYS calculates to the above expression on this form. I have tried:
initial value
force default to
default value
using a different field and saying if entered then expression else expression
And the hateful red underline will NOT go away... Any ideas? Made this work?
