Render specific text with rules

[Hyng]

Hello, 

I would like to render my report text with some rules.

If my "Total Sales" exceed 100k then render text A else render text B.

Is this possible? Thanks!

[wwatson]

I'm not totally sure I got what you were trying to do but took a stab at a solution:

[echuong1]

Are you trying to have a table with either Text A or Text B listed with the total Sales amount based on how much the total sales is? If so, you can use a conditional statement to determine with text value should be used. After that, you can use the table tool and render tool to create the table.

See attached. Hope this helps!

[Hyng · Accepted solution]

Thank you, you guys kind of give me an idea on how to do it. Attached is what I am looking for. 😄

[Hyng]

Hi there,

Follow up question, if I would like to change below return text into blue, will that be possible?

to something like this, I did that in the report text tool before but it doesn't work for rules setup. 😞