How to not displaying the number when calculate total (1 Viewer)

[mtp]

My report shows the record from 90-120days since the postdate of the amount. The user don't want to see it, but they want the total come out right when calculate the prevous balance for last couple months. I don't want to make that column (90-120days) to be 0, because when it updates for the closemonth it counts that column as 0, and the total will come out a wrong amount. How do I make it calculates without showing the number (don't show the number and only show 0.00 on the report) ? Can anyone help, please. Thank you!

 

[llkhoutx]

Hide the textbox being summed, while keeping the total calculation. Place a label with 0.00 in it on top of the textbox.

 

[mtp]

Thank you so much for your help. It's worked wonderfull.