Field 136 contains one of 4 words: Classic, Bold, Slimline, or Eco. I am trying to set up a calculation in which if the word Classic is in Field 136, then the word Classic has a value of 120, and I want to multiply 120 times whatever value is in Field 99. Classic value is 120
Bold has a value of 145
Slimline value is 160
Eco value is 50.   The calculation below is not working. Would anyone know if this is possible?   ([136] == Classic) ? (120 * [99]) : ([136] == Bold) ? (145 * [99]) : ([136] == Slimline) ? (160 * [99]) : ([136] == Eco) ? (50 * [99])