Hide Records?

[dido]

I have a field called increase which is from a formula base on one formula over another. (i.e. Amount 1/Amount 2).

This is placed in the group footer. How can I only show records where the increase is great than 10.

The formula is not an option in the select expert.

 

[cbrittain533]

Conditionally suppress the field based on its value.

Under format field in the suppress condition:

(Amount 1/Amount 2) < 10

 

[dgillz]

Your formula should be available in a record selection formula. Please post your formula so we can see it. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[dido]

The formula is

Increase = {@RunningSumTo}/{@RunningSumFrom}

RunningSumTo =
WhilePrintingRecords;
Global NumberVar RunningSumTo := RunningSumTo + {@YearToAmount};

RunningSumFrom =
WhilePrintingRecords;
Global NumberVar RunningSumFrom := RunningSumFrom + {@YearFromAmount};

I have been able to select the records by manually typing in the formula. 'RunningSumTo' and 'RunningSumFrom' both appear on the select expert, but the formula 'Increase' does not appear on the list!