9 Replies Latest reply: Jun 15, 2015 5:41 AM by Sasidhar Parupudi RSS

    amount colum require with condisions

    Anil kumar

      Dear All,

       

      i'm stuck in  creating amount coumn with codision ,

      i have attached excel sheet in which two cloumn "close_code and "po_status" , there are status in both cloumn and i need only status from close_code("closed to receiving ","open" )and from  po_status("approved") and finely with those criteria now i need to multipulate

      "QUANTITY""UNIT_PRICE"

      column and final out put will be my required value. this is very tuff to me , plz help if any one can do this  and revert asap