Crosstab Imbedded Summary Calculation
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22913
Printed Date: 29 Apr 2024 at 6:49pm
Topic: Crosstab Imbedded Summary Calculation
Posted By: bremen
Subject: Crosstab Imbedded Summary Calculation
Date Posted: 18 Nov 2020 at 4:28am
I am rather new to working with cross-tabs in Crystal. My cross-tab is very basic. I am counting he number of items in each of my warehouses and I am trying to determine how many items per day a person needs to count in order to complete a 100% inventory in a calendar year. I was able to find this formula
Roundup( (GridValueAt (CurrentRowIndex, CurrentColumnIndex ,0 ) / 365))
and it does the job nicely. I was asked, however, to have some warehouses be counted at 300% annually. How would I format if my Row 1 value = Blue or Green or Red then do math else do different math?
|
Replies:
Posted By: lockwelle
Date Posted: 18 Nov 2020 at 6:00am
I don't think that you can use can use the font color as you cannot determine it by looking at the cell (Crystal doesn't have any methods)...but you set the colors based on something, you can use the same formula to change your math.
At least that is what I would try.
I don't use CrossTabs enough to be 100%
|
|