Default Value "0" in Query Extended Price filed

Hi friends, can anyone solve my issue



How to set a Default value "0" in Query Extended Price Calculated filed ?



i have attached the screenshot with explanation can you please replay how to changes the formula.



i have used below following functions but there is no workout.

Extended Price: CCur([Qty]*[BPrice])

Extended Price: CCur(Nz([Qty]*[BPrice],0))

Extended Price: Nz([Qty]*[BPrice],0)

Extended Price: ([Qty]*[BPrice])

Extended Price: IIf(IsError(([Qty]*[BPrice])),0,([Qty]*[BPrice]))



Thanks,

Sandhya.

Attached Images

Default Value in Query Calc filed.jpg (60.6 KB)

Default Value "0" in Query Extended Price filed