8 Replies Latest reply: Mar 7, 2016 7:21 AM by Azam Mullick RSS

    Calculation error

      Hello All,


      I have to calculate the INDICE as per the attached spreadsheet.

      The formula is


      =-(1-(TMT Pondéré/TMT Cible Pondéré)


      However I need only the total to be calculated.


      Any idea?


      I tried different ways but I cannot find the solution.(even using variable)


      I copied the expression i've used for all calculation in the first row.


      Many Thanks,