Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Conditional Formatting on Crosstab Post Reply Post New Topic
Author Message
l_scull
Newbie
Newbie


Joined: 28 Jul 2011
Location: United States
Online Status: Offline
Posts: 1
Quote l_scull Replybullet Topic: Conditional Formatting on Crosstab
     Posted: 28 Jul 2011 at 11:42am
Is it possible to conditionally format a crosstab table based on a comparison of the CurrentFieldValue and the row total in a crosstab?  I am trying to get the fields to flag when they are greater than average.
 
In this case:
 
Average of row A is 3.33 -  Aug should flag
Average of row B is 1.66 - Aug should flag
Average of row C is 3.66 - June and July should flag
 
My crosstab looks like this:
 
description                  June               July           Aug               Total
A                                    3                   2               5                  10
B                                    1                   1               3                   5
C                                    5                   4               2                  11
 
In my brain, the calculation should look something like this:
 
If CurrentFieldValue > Total/12 then crYellow else crNoColor
 
I can't figure out what the field name of that Total field is.
 
Please help?
 
 
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum