3 Replies Latest reply on Feb 5, 2019 10:14 PM by Zhouyi Zhang

    Subquery translate to calculation field


      I have some subquery and i want to translate to calculation field but i can't make the value same. I already try some calculation like this

      SUM( If status = 'SUCCESS' THEN

      IF not isnull(cust_amot_id) then zn(must_pay) else zn(amount) end


      but the value still different. Can somebody help me? Thanks.