I have a Ratio Expression in Designer. I'd like to conditionally format it based on it's value within a certain range, but I'm struggling to find the right syntax for the BQL expression to do so. How do you refer to a ratio from within BQL?
Hi, Anne. I got this to work, although I initially thought you had uncovered a bug.
I put in the expression and the formatting and the whole column being formatted went blank. I thought maybe I needed to specify the default, too, maybe, but that didn't change anything.
The solution was to save the report, close it, and reopen it. Then the conditional formatting I was expecting was applied.
The expression I used as the boolean expression is:
([Sum: Discount_Amount]/[Sum: Extended_Amount])>.1
The formatting I applied:
The end result is a successful conditional format:
Thank you for the suggestion. I tried your example but I'm still getting blank results. Do you have any other suggestions?
I would suggest opening a Support ticket, then. If you are doing it the same way, you should get the same results, and if you don't then I'd suggest opening a ticket. Actually, either way a ticket is warranted, because I shouldn't have to save and reopen it in order to see it.
I have to do that often.