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

    handling null values

    Lakshmi Palisetty



      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