Skip to Content

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

Jan 27 at 10:35 AM


avatar image

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!


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers