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.
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.