Forum Discussion

Trebor84's avatar
Trebor84
Icon for Helper II rankHelper II
4 years ago
Solved

Compare two tables for rate increase

Hi,   Hoping someone can assist with this please for a custom column.    I have two tables, one with a list of staff, payment dates and amount, the other table has rate increase start date/end da...
Need Help
  • Trebor84's avatar
    Trebor84
    4 years ago

    Thanks, this works great.  Appreciate your help.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • Trebor84's avatar
    Trebor84
    Icon for Helper II rankHelper II
    4 years ago

    Hi,

     

    Thanks, this works great.  One thing I forgot to mention though was that I also need to take into account a job reference number field as an employee may be paid a second fee for the same job reference.  In the attached example employee 12345 received two payments for job ABC123 but the bonus should only be paid once and preferably against the first record.  If there are duplicate job refs then they will always be the same date and unique to just that employee so job ABC123 would never apply to another employee for example.

     

    Sample file: https://easyupload.io/8ft38c

     

    Thanks 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      Hi,

      How does one decide the order?  You said "preferably against the first record".  For employee id 12345, which is the first record.  Please give clear and consistent logic.