T
TJAC
I have a report that receives the data from a table. That table is is
populated from a make-table query.
In the report there is a calculation that says if achieved is greater than
or equal to the goal, they will receive 100% of bonus for that portion. One
person has a goal of 94.1 and an achieved of 94.1 receiving 0% of bonus.
Another person shows 96.4 for goal and achieved is 96.4 receiving 100% of
bonus.
Now in the make-table query there is rounding coded into it saying to round
it to 1 decimal. When that was changed, you can see that the 94.1 was
actually rounded up and she really should not receive her bonus. We did take
it out a few more decimals to avoid any confusion.
However, my question is if this information is stored in a table, how did
the report know that wasn't the true number? I am so confused by that. I
would understand if it were retrieving the information from a query, but how
does the report know what the table says isn't really so. The table itself
only has the 94.1
Thanks!
populated from a make-table query.
In the report there is a calculation that says if achieved is greater than
or equal to the goal, they will receive 100% of bonus for that portion. One
person has a goal of 94.1 and an achieved of 94.1 receiving 0% of bonus.
Another person shows 96.4 for goal and achieved is 96.4 receiving 100% of
bonus.
Now in the make-table query there is rounding coded into it saying to round
it to 1 decimal. When that was changed, you can see that the 94.1 was
actually rounded up and she really should not receive her bonus. We did take
it out a few more decimals to avoid any confusion.
However, my question is if this information is stored in a table, how did
the report know that wasn't the true number? I am so confused by that. I
would understand if it were retrieving the information from a query, but how
does the report know what the table says isn't really so. The table itself
only has the 94.1
Thanks!