Record selection using formula

[p8ass8]

I am calculating percentage total in a formula.

I want to be able to select those records where percentage total is above 1%. However, the select expert doesn't list this field and I don't know how to filter the report for those records with percentage total above 1%.

Any help would be appreciated.

 

[synapsevampire]

Please post specifics in the future, we need to know what's in your formula, your Crystal version, the database, where this percentage is supposed to be and of what, etc.

Here's some basics.

Group by an entity
Place the field in the details, right click it and select insert->summary->sum (or whatever)
Select Summary Location at your group level
Options will turn on the Show as a percentage of, select it and leave it as a grand total
Use Report->Selection Formulas->Group and place code akin to:

PercentOfSum ({table.field}, {table.groupfield}) > 1

Substituting your database fields.

-k