3 Replies Latest reply: Jan 24, 2012 2:08 PM by anubankar RSS

    Scripting for price comparison

      Hi All


      I have a QVD file that has client proposals data. Various versions are created based on client feedback. My aim is to find out the discount given starting from base proposal. The data in QVD files is as follows:



      "Estimate"     "Estimate Copied From"     "Price"      

        X                  -                                       1000        

        Y                  X                                       900        

        Z                  Y                                       800        

        Z11               Z                                       750


      Note: No of iterations is not fixed.



      Sales Order     Estimate

      4040               Z11


      I want report o/p as follows:

      Sales Order    Discount Given

      4040               (1000-750) = 250


      Any idea how I can achieve this?