Hi,
I have a report that summarizes activities on a monthly basis (sample is attached). I'd like to add a condition to columns 2 to 12 that
give an indication that its value is greater or less than the previous. I'd be happy if I could get the font color change to red if the value
is lower, or green if the value is higher.
I know I can't get at the value of the text component, but thought I might be able to use something like the expressions I have in
GroupHeader text boxes.
In the Expression for a Highlight Condition, I've tried the following...
{CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==2) < CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==1)}
and also...
CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==2) < CountIf(GroupHeaderBand1,Month(WorkOrders.BeginDate)==1)
Is there an expression you could suggest that would work in this case?
Thanks,
Carl
expression in conditions
expression in conditions
- Attachments
-
- PerformanceMeasures.mrt
- (50.8 KiB) Downloaded 303 times
-
- PerformanceMeasures.pdf
- (97.47 KiB) Downloaded 187 times
Re: expression in conditions
Hello,
In the Condition, you can use Totals function for this task.
Also, you can use additional variables for this task, which calculate in the Text expression or in events and then use in the Condition.
Thank you.
In the Condition, you can use Totals function for this task.
Also, you can use additional variables for this task, which calculate in the Text expression or in events and then use in the Condition.
Thank you.