4 Replies Latest reply: Apr 20, 2016 4:33 AM by Abhishe Mishra RSS

    Reference variable from excel under a column to the expression in the straight table

    Abhishe Mishra

      Hi All,

       

      I am trying to refer a column in a excel which has the variable names stored in it.

       

         

      KPI NameKPICalculationVariable
      KPI1vKPI1Calculation
      KPI2vKPI2Calculation
      KPI3vKPI3Calculation

       

       

      I want a straight table where we have the KPI Name and the KPI values evaluated. I do not want to use nested if to evaluate the expression for KPI value as there are about 50 KPIs

       

      Could anyone help?

       

       

      Thanks

      Abhishek