Minumum Amount is showing 0 as null value and not the actual minimum

[lumier]

I have a field on my crystal 8.5 report that I need get the minimum and maximum amount. I am able to get the maximum amount but not the minimum. If there are records that have a null value, the mininum is showing 0 when it should should the minimum dollar amount in that column. Any suggestions on how to accomplished this would be appreciated

 

[Turkbear]

Hi,
If the field is NULL, how can it show something else?
If you can determine the correct minimum ( from some other field, perhaps)then use a formula like:

If IsNull({field}) then {fieldthathasminimum}
else {field}





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

Use a running total, which includes minimum/maximum. Add a formula test, to exclude nulls.

Right-click on a field and choose Insert to get a choice of Running Total, Summary etc.

If that fails, write a formula and put it in the detail line:

if isnull({your.field}) then 999
else {your.field}

Get a minimum for that field, and then suppress it on the detail line so it doens't spoil the look fo the report.


Madawc Williams (East Anglia, UK)

 

[lbass]

If you have the option, you could exclude null values from your report by using a record selection formula of:

not isnull({table.value})

-LB