>Basically, I'm using the exact same formula the original commissions were calculated with only difference that I want them broken down by categories.
>
>I'm not sure what should I do. Use Numeric 11,2 instead of currency for my calculations as well?
Naomi,
I think the solution isn't in choice between
Numeric OR
Currency datetype field.
The solution is in calculations and rounds in exactly steps in program or Report.
For all your calculations and reports you need to use the same strategy for calculations and rounds.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst