5 Replies Latest reply on Nov 21, 2018 5:44 AM by Lakshmi Palisetty

    handling null values

    Lakshmi Palisetty

      Hi

       

      I have created one calculated field like below:

       

      Over ride Price:

       

      zn(sum(If [Condition Type] = "ZR02" then ([Condition Value]) else 0 end)

      -

      sum(If [Condition Type] = "ZR03" then ([Condition Value]) else 0 end))

       

      But i have to handle below scenario also

       

      • For Override Price – When ZR02 is blank and ZR03 has a value then it should take ZR03 value for Override Price (-ve value should not come)

       

      Please find attached twbx

       

      Thanks