This content has been marked as final.
Show 3 replies

Re: Conditional Coloring of Text in a Text Box. (make negatives red)
Daniel Oberbillig May 13, 2015 9:01 PM (in response to Allan McMordie )You could write the expression once in a variable e.g.
vVar = sum(sales)
if($(vVar)>0,green(), red())

Re: Conditional Coloring of Text in a Text Box. (make negatives red)
Michael Solomovich May 13, 2015 9:05 PM (in response to Allan McMordie )1. Expression results are cached. That means if two expressions are exactly the same, they are calculated once, not twice. But if they are even a little different (sum in one but Sum in another)  each will be calculated.
2. Not exactly  but think of keeping expressions in variables. So, the variable eBudget contains expression for Budget calculations, and variable eSales  for Sales calculations.
Hope this will help you.