Forum Discussion
My Calculation does not work
I am building a DB where I have one table called Sales Info Table and, in that table, I have a calculated field called QTR1-SALES-ACTUAL, and say the field has a calculated number in it of $485,000. ...
what is the Result Type of your Calculated field? (it should be Currency or any high precision datatype, like Decimal).
also what is the datatype of the field where you get $1?
also what is the datatype of the field where you get $1?