4 Replies Latest reply: Aug 10, 2017 12:55 PM by Wallo Atkinson RSS

    Dynamic Formula Calculation in Table

    Omkar Kakade

      Hello All

       

      I am reading one file which containing formulas for each row. In table I want to calculated each formula for each row in table.

       

      Example

       

      tblCounter

      counterIDCounterNameCounterValue
      1John10
      2Smith12
      3Ron23
      4Rock23

       

      tblFormula

      formulaIDFormula
      1sum(John(CounterValue)) +sum(Ron(CounterValue))
      2sum(Smith(CounterValue)) +sum(Rock(CounterValue))

       

      I want to show Table with Formula and its calculated value

       

      Header 1Header 2
      sum(John(CounterValue)) +sum(Ron(CounterValue))33
      sum(Smith(CounterValue)) +sum(Rock(CounterValue))35

       

      I have tried to add $ Expression in measure. But I am getting Blank value in Table.