How can I ignore 0 values from Crystal Report .
Posted on 2004-03-28
I have a database in MSAccess 2000 and VB programme .
And Also I have created Summary report using Crystal Report 8.5
There I have 3 values .
Ex . A1 = 50 , A2 = 0 A3 = 25
Using this I want to get Max of A = 50 and Min of A = 25 and Avg of A = 37.5 to take this values I want to ignore A2 = 0 .
Please help me to ignore 0 values from crystal report . But 3 records should be there .
I am Not Mean "<>" symbal . If I use this I can't take Total records are as 3 .