|
Hello All,
Let me say thank you in advance! I'm working on a crystal report that tracks different types of registrants for an event of this year versus last year and I'm using a crosstab with the headers 2009 YTD and 2010 YTD. I want to compare the values in 2010 YTD and 2009 YTD by using conditional formatting so that where we are ahead appears in green and where we are behind appears in red.
I'm having a hard time with this because the field name is the same for 2009 and 2010. I think I need to do something like the below, but it's not working.
If CurrentFieldValue in [2009 - YTD] > CurrentFieldValue in [2010 - YTD] then crRed
|