1 of 1 people found this helpful
Community can correct me if I am wrong, but I do not believe there is any built-in way to do conditional formatting in the tooltip. What you'd have to do is build two version of each calculation, and make sure one evaluates to a null when conditions are met, and the other does not, and vise versa. Then you could put both versions of the calculation in your tooltip with static formatting, but only one would show up.
So a simple example may look something like (pseudo code to follow):
if sum([Field]) < 0 then sum([Field]) end
if sum([Field]) >= 0 then sum([Field]) end
I made small changes to workbook attached by Vishwanath to make it match better with your requirements. Let me know if i'm wrong.
Sales KPI Tooltip_AVR.twbx 984.1 KB
Yes! This is exactly it! I knew that our training consultant had showed me this and really wanted to use it to show some of the key things done during this fiscal year. Thanks so much
Vishwanath and Venkat:
Thank you both! Your workbooks helped me a lot this morning!