Joined: 28 May 2013
Online Status: Offline
Posts: 93
Topic: Crosstab Imbedded Summary Calculation 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
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?
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
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.
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
IP Logged
