Hi Everyone,
We have been working all day on a report for a medical office that lists all the lab tests they do, with the amount billed and total paid on each. We then tried to total the amount billed and amount paid columns for all the tests. We could not get the calculated fields to work--in the expression builder it gave us an error that the expression was incomplete or invalid. When we tried it on a laptop that we use (with a backup from the desktop) it worked fine and accepted the calculation. We noticed that the laptop said it was Ver 11 build 3177. So, we decided to update the desktop, thinking that might be the problem. When we updated it, we got build 3044--which seemed wierd since the desktop back up was more current and the build # was lower.
After the update, on the desktop, when we make the grand total calculated field by adding all the individual calculated fields of the charges, it still says invalid or incomplete expression(even after the first field is entered). But if we put this "bad" calculated field onto the report--it runs the calculation correctly! We copied the report from the laptop and put it on the desktop and when we go into the calculated field editor it still gives the error. The laptop accepts the equation, but does not give a correct value until the report runs( which I understand because it is based on prior calculations that need to be run first). But by accepting the calculation we knew we could try the formiula. We spent hours trying to figure out what we were doing wrong with the calculation--it was just simple addition--when we were actually doing it correctly.
Can someone look into this?
We have been working all day on a report for a medical office that lists all the lab tests they do, with the amount billed and total paid on each. We then tried to total the amount billed and amount paid columns for all the tests. We could not get the calculated fields to work--in the expression builder it gave us an error that the expression was incomplete or invalid. When we tried it on a laptop that we use (with a backup from the desktop) it worked fine and accepted the calculation. We noticed that the laptop said it was Ver 11 build 3177. So, we decided to update the desktop, thinking that might be the problem. When we updated it, we got build 3044--which seemed wierd since the desktop back up was more current and the build # was lower.
After the update, on the desktop, when we make the grand total calculated field by adding all the individual calculated fields of the charges, it still says invalid or incomplete expression(even after the first field is entered). But if we put this "bad" calculated field onto the report--it runs the calculation correctly! We copied the report from the laptop and put it on the desktop and when we go into the calculated field editor it still gives the error. The laptop accepts the equation, but does not give a correct value until the report runs( which I understand because it is based on prior calculations that need to be run first). But by accepting the calculation we knew we could try the formiula. We spent hours trying to figure out what we were doing wrong with the calculation--it was just simple addition--when we were actually doing it correctly.
Can someone look into this?
Comment