Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try:
=$(=Formula)
This doesn't resolve the expression at all.
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)
How are the values exactly in the field?
like: 2*2*3 , "2*2*3" or with single quotes?
In this way 2*2*3
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.
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