I am making a crystal report which displays values from database. Now the values from db contains duplicate values.

I need that duplicate values should be suppressed and should display 0.00

For Ex.

Value

* 250.00
* 250.00
* 250.00

Should display

* 250.00
* 0.00
* 0.00

I have applied "Suppress Duplicate" to the column but don't know how to display 0.00 there.

Thanks much!