
Re: Dynamic Formula Calculation in Table
Andrea Gigliotti Aug 10, 2017 12:04 PM (in response to Omkar Kakade)use below:
sum( {< CounterName = {"John"} >} CounterValue )

Re: Dynamic Formula Calculation in Table
Naresh M Aug 10, 2017 12:13 PM (in response to Omkar Kakade)Hi Omkar,
Try with this below formula, it will work.
1. sum({$<CounterName={'John'}>+<CounterName={'Ron'}>}CounterValue)
2. sum({$<CounterName={'Smith'}>+<CounterName={'Rock'}>}CounterValue)

Re: Dynamic Formula Calculation in Table
Sunny Talwar Aug 10, 2017 12:23 PM (in response to Omkar Kakade)$ sign expansion is probably not going to work as it doesn't work on row by row basis. May be you need to use Pick Match or if statement to get this done... don't understand this too well to give you a solution for the problem... may be post a sample

Re: Dynamic Formula Calculation in Table
Wallo Atkinson Aug 10, 2017 12:55 PM (in response to Omkar Kakade)Not exactly sure what you need. But you could try the following example
Assuming you're using inline tables your formula in the inline script would be (including the beginning and end double quotes) Repeat for all the formulas you need.:
''sum({<CounterName={'''John'''}>}CounterValue)+'sum({<CounterName={'''Ron'''}>}CounterValue)'''
Then your dimension would be (Your header 1)
=$(=Formula)
and your Expression would be (Your header 2)
=$(=($(=Formula)))