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.

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

Hi,

 

They could appear in any order unfortunately due to issues with the source data. I could add an index column maybe to then do a count on job ref and return 1 for new job and zero if job exists previously on another row.

 

Then the bonus would only appear against a record with a 1 in in it?

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

So please do so and share the revised file.