I'm using a text object to show the Actual for the month selected. I'm including arrow icons to show if they are negative of positive. Now i need to color it red or green accordingly.
I could do this in a chart table using column() function in background property of the expression. Could you please help me in doing the same in a text box as well.
I understand that the formula could be repeated, however i'm concerned about the maintenance issue it might pose in the future.
In a text object you will have to repeat the expression, however that being said rather put the expression in a variable and then use it in the text object. This way will make maintenance the same as using Column() in a chart.
Remember when using variables, never include the equal '=' in the variable expression, otherwise it will be calculated without dimensions, when leaving the equal out it will calculate on the object.
In a text object you will have to repeat the expression, however that being said rather put the expression in a variable and then use it in the text object. This way will make maintenance the same as using Column() in a chart.
Remember when using variables, never include the equal '=' in the variable expression, otherwise it will be calculated without dimensions, when leaving the equal out it will calculate on the object.
