Skip to Content

How to compare a row value with a calculated field in a crosstab

Good day

I have written a crosstab report in Crystal 2011 which shows a list of stock items, quantities on hand and sales per month. I created a formula to calculate average sales and added that as a summarised field. I only want lines to display on the report of items which stock on hand is lower than the calculated average divided by 2. (Average Sales)/2

I tried GridvalueAt and CurrentFieldValue but cannot seem to get the suppression right.

My report looks like this:

Line 1 must be displayed because the stock on hand of 0 is below the (27/2) = 13.5

On the other hand line two is above (34/2) = 17 and should be suppressed.

Can somebody please help me how to achieve this?

Thank you!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers