jen
01/09/2020, 12:09 AMCASE WHEN {custbody_application.custrecord_operations_pcnt_1} > {custbody_application.custrecord_operations_pcnt_2}
AND {custbody_application.custrecord_operations_pcnt_1} > {custbody_application.custrecord_operations_pcnt_3}
AND {custbody_application.custrecord_operations_pcnt_1} > {custbody_application.custrecord_operations_pcnt_4}
AND {custbody_application.custrecord_operations_pcnt_1} > {custbody_application.custrecord_operations_pcnt_5}
THEN {custbody_application.custrecord_operations_1.id}
WHEN {custbody_application.custrecord_operations_pcnt_2} > {custbody_application.custrecord_operations_pcnt_3}
AND {custbody_application.custrecord_operations_pcnt_2} > {custbody_application.custrecord_operations_pcnt_4}
AND {custbody_application.custrecord_operations_pcnt_2} > {custbody_application.custrecord_operations_pcnt_5}
THEN {custbody_application.custrecord_operations_2.id}
WHEN {custbody_application.custrecord_operations_pcnt_3} > {custbody_application.custrecord_operations_pcnt_4}
AND {custbody_application.custrecord_operations_pcnt_3} > {custbody_application.custrecord_operations_pcnt_5}
THEN {custbody_application.custrecord_operations_3.id}
WHEN {custbody_application.custrecord_operations_pcnt_4} > {custbody_application.custrecord_operations_pcnt_5}
THEN {custbody_application.custrecord_operations_4.id}
ELSE {custbody_application.custrecord_operations_5.id} END