Reports Min/Max for variable

[TinLegs]

I have a C6.1 ABC app and on the report footer I have Clarion calculate the Max and Min values of a numetric variable. The problem is that the variable is not a 'Required' field therefore for some records it can be omitted and results in the Min value being reported as zero.

It is these blank (zero) records I wish to exclude from the 'Tally' calculation so that the Min reports the lowest of the recorded value.

Can this be done conditionally or otherwise?

Thank you

 

[TinLegs]

For those interested in this problem it appears not. I have obtained the result I wanted though hand coding, it was just that I preferred the calculation to be made by Clarion.