3 Replies Latest reply on Nov 22, 2018 1:24 PM by Jennifer VonHagel

    Comparison Operator

    Lakshmi Palisetty

      Hi Al,

       

      I have tried below requirement by creating 4 calculated fields for each column ,still unable to meet requirement.

      Can anyone help me in this

       

      1st List Price ZRO2 (column) if it highest amount compared to ZZ00 or ZR03 or ZADD

      2nd List Price VC ZZ00 (column) if it is the highest amount compared to ZR03 or ZR02 or ZADD

      3rd Override List Price ZR03 (column) if is the Highest Amount Compared to ZZOO or ZR02 or ZADD

      4th if all are blank then use Yumu (column)

       

      Please find attached .twbx