Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
% over 200,00 formula
- Thread starter ChipF
- Start date
Hi !
Create two formulas.
The first one you place in the detail section
if {yourfield} > 200000 then
1
else
0
Place the other formula in the report footer like this:
WhilePrintingRecords;
(Sum({@formula1}) / Count({yourtable.loanid})) * 100 //(The count can be on any field in your detail section)
Hope it helps.
/Goran
Create two formulas.
The first one you place in the detail section
if {yourfield} > 200000 then
1
else
0
Place the other formula in the report footer like this:
WhilePrintingRecords;
(Sum({@formula1}) / Count({yourtable.loanid})) * 100 //(The count can be on any field in your detail section)
Hope it helps.
/Goran
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question