Load Expression Formulas

[ebc]

I am trying to load a list of formulas that I want to calculate in expressions. Once I have loaded some data and a list of metrics along with their formula, I am trying to use a dollar sign expansion on each formula to create the expression.

I essentially created a table that lists out each metric that I want to calculate. The problem I think I am having is trying to use a different formula in each row (see attached example). The calculation works fine when I have a single metric selected but cannot calculate when I list out all metrics.

[Gysbert_Wassenaar · Accepted solution]

See this discussion: Expressions in Fields. In particular jontydkpi's answer.

[Anonymous]

as far as i know, that is not possible the way you are attempting. but options to consider:

option 1: if the numbers are going to be static since you used {1}, you could try alternate states but this is not a clean solution at all...it will get messy with too many objects as the number of metrics increase!

option 2: i rather do it as variables and calculate them there. pfa.

edit: i totally forgot about Jonathan's reply! thanks for reminding me again!