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

    Calculating on aggregation column from granular level

    Basavareddy patil



      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