Calculating UK National Insurance rates
Dear all, I am working on a costing overview but are challenged by adding UK National Insurance (NI) on top of the base salary for our employees. Employees are categories into different National Insurance Category Letters following the below rate structures on a weekly basis. My data is structured in daily shifts per employee with base salary [ActualCost] and NI Category in seperate coloums as seen below. Initial idea is to do a SWIFT/IF statement related to a seperate NI Cateogry table, however I cant get my head around it as the daily costs needs to be summed into Weekly costs in order to calculate the correct NI payable. Thank you so much in advance.
