Evaluating expression out of a database string

[#1]

Hi everyone

I have the following expression

=$(=2*2*3)

This returns, as expected, 12.

Now if I use

=$(='2*2*3')

it also returns 12,

In my dashboard I need to load this mathematical operation out of a database. Therefore I made a field named Formula in a database table. If I make the expression this way

=$(='Formula')

it returns, as exprected, the text "2*2*3". But I want to have it calculated.

Therefore I tried =$($(='Formula')) or =$(=$(='Formula')) but neither of them seems to work. Is there a way to solve this problem and to calculate the content of the Formula field?

Thanks in advance for any help.

[tresesco]

Try:

=$(=Formula)

[#3]

This doesn't resolve the expression at all.

[Anonymous]

Create the expression as a variable and call that variable in the expression

LET Var = '=$(='Formula')'

or

LET Var =$(='Formula')

and in the expression window use $(Var)

[tresesco]

How are the values exactly in the field?

like: 2*2*3 , "2*2*3" or with single quotes?

[#6]

In this way 2*2*3

[#7]

unfortunately none of the both variants work. In the upper example LET Var = '=$(='Formula')' it is interpreted as a string, and the lower it has the same behaviour as in my code.

[jerrysvensson]

I don't know if I fully understood, but this works.

test:
LOAD * Inline [
Formula
2*2*3
];

Then add this expression to a textbox

=sum($(=Formula))

This will return 12