IIf statement with ending result (1 Viewer)

[Joe8915]

I have a text box with the following statement:

Summary detail: Sum(IIf([dacthc]=0,Null,Fix(100*[dqty]*([dstdhc]*[drate]/[dacthc]-[drate]))/100))

My question is, if it meets the criteria, is it possible to make it default to a "0" in the field.

Thanks for taking the time to look and review

 

[Sketchin]

Summary detail: Sum(IIf([dacthc]=0,0,Fix(100*[dqty]*([dstdhc]*[drate]/[dacthc]-[drate]))/100))