on 03-11-2015 5:34 PM
I have a crosstab showing the grand total (average) for the rows, at the right end of each row.
How can I create a format field formula to compare the cell value (average) in that row to the grand total, and if it that cell is "greater" than the grand total, highlight that cell in yellow?
Thanks for any help.
Hi Cheryl,
Would you be able to send the report with saved data please?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Abhilash fixed my formula, so it works correctly now:
If Int (Truncate(CurrentFieldValue/60)) + Int (Remainder (CurrentFieldValue, 60)) > Int (Truncate (GetTotalValueFor ("your field")/60)) + Int (Remainder (GetTotalValueFor ("your field"),60)) then crYellow else crNoColor
Thanks Abhilash!
Also thanks to everyone else for their helpful input.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try this, you will have to enter your Field name but it should work:
If CurrentColumnIndex > GetTotalValueFor ('Field you have in the crosstab') then CrYellow
Else NoColor
Where you enter your field you have to remove the { } and but ' ' at the beginning and end.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
See this: Highlighting Values in a Crystal Reports Crosstab based on sibling values - Stack Overflow
I hope this helps you..
--DJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.