Hello:
Good morning. I have a question. I want to mark all negative value in () as red in output. How can I achieve that?
| 1,061 |
| (9,290) |
| (415) |
| 9,696 |
| (429,731) |
| (234,784) |
| (1,405) |
| (10,010) |
| (1,243,164) |
Appreciate your time and efforts.
Thanks
Solved! Go to Solution.
Thank you. Appreciate your help. :)
Hello @MilindG I really appreciate your help on text color into red question. Do you mind to share me the workflow? I am facing difficulties to see details on the Screenshot. Another question is what if in the excel instead of () if the symbol is - is given? Appreciate your responses.
@Kinetic_analytics Okay I have attached the workflow. Not too sure about the excel however in Alteryx, you can try the where I have the formula Contains([_CurrentField_], '('), you can change that to Contains([_CurrentField_], '-')
Thank you.
