Can I reference value of a text object in a formula?

[#1]

Is it possible to reference the value of a text object in a formula?

I have two text objects that display percentages. I also need to display the difference between the two percentages.

Is is possible to refer to the value in the text object directly (e.g Difference = Text1.Value - Text2.Value) or will I need to write out the formula including the formula for both the text objects (e.g Difference = (entire formula for calculating Text1) - (entire formula for calculating Text2) )?

I only ask because I will need to repeat this kind of thing many times in the dashboard.

Any help or ideas would be greatly appreciated

[#2]

Hi,

Please try this: Difference = GetFieldValue(Text 1) - GetFieldValue(Text 2).

[tresesco · Accepted solution]

No you can't refer like that directly. Alternatively you can think of using variables to hold the expression value and use that variable as and when needed.

[#4]

Thanks, I thought that might be the case