My application contains a form that uses linked fields to input information into the database as follows:
Field A
|
--------> If Field A = x then Field B = y
|
--------> If Field B = y then Field C = z
Field C is a percentage field in the original form and when used inputs the correct value in the linked form. So the data is correct.
However, when I perform a Deluge calculation with the value using the value from the linked form, it seems like Deluge pulls the record ID as a value, rather than the value itself. So, instead of using the percentage value that I need, it uses the lengthy ID field that provides nonsense as a result.
The formula (in a Formula Field) is as follows: Field_B/100 * Amount
In Deluge it would be: variable = (input.Field_B/100) * Amount
Why am I getting the ID number instead of the field value?