6 Replies Latest reply on Sep 18, 2014 8:07 PM by Basavareddy patil

    Calculating on aggregation column from granular level

    Basavareddy patil


      Hi,

       

      There are 2 spreadsheets i have attached product data.xls and product cost.xls.

       

      I have requirement to calculate Current value Vs Desired value  at Product Level.

       

      Logic -

       

      Step1 - Cal1 = Calculate current value vs Desired value(Current value/Desired value) at application level

       

      step2 - Cal2 = Cal1 * Prodcut cost.cost (From prodcut cost.xls. Cost of each application)

       

      step3 - Cal3 = SUM(Cal2)/SUM(Prodcut cost.cost) (at product level)

       

      Final Result should be as below

      Product Cal3

      P1         0.79

      P2          0.80