0 Replies Latest reply: Aug 26, 2014 4:39 AM by jörn kunz RSS

    Insert variable values in a excel table

      Hello everybody,

       

      how can i manipulate an Excel List. I have a original table with data inside. I saved formulas as variable. My Goal ist to save the solution of the formulas in a new Excel list (calculated table)

       

       

      Original table

      figures
      Revenue I1
      Revenue II2
      Cost I4
      Cost II5

       

       

      Here you see my formulas in the LOAD:

       

      Sum ([Revenue I + II]) = sum(if(figure='Revenue I') + sum(if(figure='Revenue II')

      Sum([Cost I + II]) = sum(if(figure='Cost I') + sum(if(figure='Cost II')

       

      Div([Cost/Revenue]) = $(Sum([Revenue I + II])/$(Sum([Cost I + II])

       

      Calculated table

      figures
      Revenue I1
      Revenue II2
      Sum(Revenue I+II)3
      Cost I4
      Cost II5
      Sum(Cost I +II)9
      Div([Cost/Revenue])3

       

      I hope someone understand my Problem and know how to solve this Problem.

       

       

      Thanks.