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...
Hi Brirack77
A Power Query option in attached file with
- Sheet 'Data', 2 tables named SetOne & SetTwo
- Sheet 'Result' the output of the query (pic. cropped):
How To use:
- Enter your data in the SetOne & SetTwo tables (they can be on seperate sheets)
- Switch to sheet 'Result'
- Right-click somewhere in the green table > Refresh*
* Can auto-refresh every n minutes if necessary but I wouldn't recommend with 2K Emp.
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...
