AnsweredAssumed Answered

*

Question asked by Stevehou on Jun 19, 2012
Latest reply on Jun 19, 2012 by philmodjunk

Title

*&^% Should be Easy - Insert Calculated Value from a Value List

Post

 I have two fields and one script.

Field One is called Restitution.  It has a value list with two values:  Initial and Final.

Field two is a field that gets filled by a "Insert Calculated Value" script.

I cannot get my "Insert Calculated Value" to work if both checkboxes in the value list are checked (Initial and Final)

"Insert Calculated Value" calculation goes like this:  Case(Restitution = "Initial Final", "Both initial and final restitution has been addressed", "Restituion is not yet resolved")

I've also tried, (I've tried many other combinations too)

"Insert Calculated Value" calculation goes like this:  Case(Restitution = "Initial" and Restition" = "Final", "Both initial and final restitution has been addressed"), "Restituion is not yet resolved"

It works when my calculation includes one of the values but not when it includes both.  This works:   Case(Restitution = "Initial", "Both initial and final restitution has been addressed", "Restituion is not yet resolved")

Anyone know how to capture both variables from my list

Outcomes