Conditional Sum with different dates

[#1]

Dear all,

I need to show in a  chart employee last year salary on a table that comes with all salary based on different dates.

Basically the table have:

employee_name

emplyee_company

employee_salary_from

employee_salary_to

employee_salary

Each employee comes with different rows each and the last one is just the one where the field employee_salary_from is filled with a date and the field employee_salary_to is not filled.

I'm unaware on how to sum only the last salary (the one where employee_salary_to is empty).

Cold someone help?

Thank you

[Gysbert_Wassenaar · Accepted solution]

Ah, yes, a typo. Change it to To_salary.

The load statement is a preceding load. The source table is the record set returned by your SQL statement. See this blog post for an explanation: Preceding Load

[#3]

It works!!!!! Many thans Gysbert! You give me a new way to look at solutions.

Have a nice day!