Colour Formatting within Report Text Tool

[JoeHodgetts]

Hello,

Is it possible to take coloured text from a Report Text tool and then embed this within another Report Text tool? I have put a basic visual below, but imagine we have multiple records with the options of 'up' 'down' and 'flat', therefore I can't just use the first Report Text tool to accomplish this as I need to join the variations - see more in the attachment.

If there is a tidier way of filtering out and formatting the data, then this is also welcomed!

Text Input

Last Week

Up 15%

Report Text

Text Data

[Last Week:A]

Report Text 2

Text Data

Sales were [Last Week:A]

Browse Tool - Desired Output

Last Week

Sales were up 15%

Thanks,

Joe

 

[Christina_H]

As an option, you could apply conditional formatting within a table tool: