Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create a text with dynamic figures...
eg. The total road accidents has increased / decreased by 15% YOY. The market has shown a 12% increase /decrease.
The red texts are dynamic in nature and are dependent on the results that we are getting from a graph. This graph is again dynamic in nature and is dependent on the selections made.
Please advice as to how this can be done..
Thanks in advance.
You can use an expression to construct the text you want to display.
='The total road accidents has ' & if( ...something... > 0, 'increased', 'decreased') & ' by ' & ...expression-to-calculate-percentage-here... & ' YOY. The market has ....etc'