Can I reference value of a text object in a formula?
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.