Hi all, doing some work for the Finance team for their general ledger accounting. I have the following scenario:Salary of £1315.33 needs to be split across 3 account codes, each of which has a different percentage:
60% = 789.20
29% = 381.45
11% = 144.69
So, I've built a query to do this...