i need to build a table of Commissions.
The commission amount is a calculated field.
I dont believe I can put the calculated amount in the table.
But how can I put that same amount on a report?
Do I have to also calculate that commission on the report as well?
I would prefer for that calculated commission amount to be in the table
Any quidance will help.
I dont know the recommended practice.