
1. Re: Stumped by Weird Calculation Results
LaRetta_1 May 17, 2011 4:47 PM (in response to projay)What is that ONE invoice displaying? Nothing?
If so, I would suspect that cBalanceDue does NOT equal 0 but might have a small fraction such as .0004 in it. Place cBalanceDue on a layout and click into it. What does it show?
It might also be your paid field ... click into it and make sure there is not a space or carriage return and that the text says precisely Closed.

2. Re: Stumped by Weird Calculation Results
projay May 17, 2011 5:10 PM (in response to projay)Wow...that is exactly right, it reads .00014. So how do I overcome this...to read as a 0?
Jay

3. Re: Stumped by Weird Calculation Results
philmodjunk May 18, 2011 9:36 AM (in response to projay)Use the Round Function to round your results to the nearest penny or whatever decimal place is correct. You can include the round function in cBalanceDue or in the above calculationwhich is correct can depend on how you use cBalanceDue in other calculations. Given that this is currency, you probably want to round your results to the nearest penny in the cBalanceDue calculation.
If you used it in the above calculation, it would look like this:
If (Round ( cBalanceDue ; 2 ) = 0 and order_open_closed="closed" ;"PAID" ;"" )

4. Re: Stumped by Weird Calculation Results
LaRetta_1 May 18, 2011 11:35 AM (in response to projay)I would need to suggest a bit differently, Phil.
cBalanceDue will be a figure Jay will be using a lot. cBalanceDue should be rounded in its own calculation. Then this Status could be:
not cBalanceDue and order_open_closed="closed" ;"PAID" )

5. Re: Stumped by Weird Calculation Results
philmodjunk May 18, 2011 12:02 PM (in response to projay) 

7. Re: Stumped by Weird Calculation Results
projay May 19, 2011 8:36 PM (in response to projay)Hey everyone that was the the ticket....it took care of my issue. I just did the Round on cBalancedue and worked great.
Many thanks to both of you in taking the time to share the tidbit.
Jay