Forum Discussion
Formula help - daily pay vs supplement monthly payments
Hi all, I have two sets of data for bonus calculations. SET ONE is in multiple rows by employee, e.g. the annual pay from 1 Jan to 31 Mar. Then 1 Apr to 31 Dec - when their pay has changed from 1 A...
Thanks Lorenzo, this does work for most employees but not all - it seems to skip one supplement line for certain employees - help!
Brirack77
OK but without actual data I don't see what I can do. Please provide a realistic - anonymized - sample of records where this fails. Thanks
EDIT: Take your time, I'll be off the next couple of days...