- Joined
- Nov 18, 2006
- Messages
- 1
- Reaction score
- 0
I built a query to calcuate the indicator by the following formular:
(Balance of Month1 - Balance of Month1) / Balance of Month1. The result numbers are 0,1,2,3,4,5,6,7
After I click the view, there is no problem. The result showed up nicely, with 0,1,2,3,4,5,6,7...... Once I put 1 or 2,... as parameter in the criteria of indicator, there is a error: Overflow. The most strange thing is: if I put 3 or higher, the error showed up immediately. If I put 1, there is a 3-seconds gap before teh error poped up. I clicked ok, then all the cells of all fields turned: #Name?. Help!!! Guys I need to finish this before the end of this quarter break. Otherwise, I got be asskicked by my advisor. Thanks
(Balance of Month1 - Balance of Month1) / Balance of Month1. The result numbers are 0,1,2,3,4,5,6,7
After I click the view, there is no problem. The result showed up nicely, with 0,1,2,3,4,5,6,7...... Once I put 1 or 2,... as parameter in the criteria of indicator, there is a error: Overflow. The most strange thing is: if I put 3 or higher, the error showed up immediately. If I put 1, there is a 3-seconds gap before teh error poped up. I clicked ok, then all the cells of all fields turned: #Name?. Help!!! Guys I need to finish this before the end of this quarter break. Otherwise, I got be asskicked by my advisor. Thanks