Problem with sum in form

[rogerarce]

Hi. I have the following problem. I have a form and I have
2 subforms. I made sums calling data from the subforms. Everything works fine. ie
=Forms!inventory![In subform].[Form]![totalIn]
=Forms!inventory![Out subform].[Form]![totalOut]

The problem starts here, in the balance:
=([In])-([Out])

If one of the boxes has a 0 value, it does not show the balance.
I hope you can understand what I try to do. Thanks for your help.

 

[WMcGregor]

I believe the problem might be when one of the boxes is null. If you use =nz([IN],0)-nz([Out],0) it should work the way you want it to.

 

[rogerarce]

Thank you WMcGregor. It worked great!.