Hi all,
I have a question regarding calculated columns in Dataverse which I hope you can help me with.
Let's say I have a table in Dataverse that keeps track of employee salaries each month.
Each month, a new record is created for each employee with Date, Base Salary, Extras, Deductions and Final Salary.
Final Salary is a calculated column: Final Salary = Base Salary + Extras - Deductions.
Date, Extras and Deductions are inputted every month.
Base Salary, however, is a fixed value, kept as a field in another table.
At record creation, the Final Salary calculation occurs fine.
However, let's say the employee gets a raise and Base Salary changes. As far as I understand, all Final Salary amounts for previous months would get recalculated based on the new value of Base Salary, which would be wrong.
So my question is, is there a way to make calculations 'snapshot' the value of a field at record creation, rather than be updated whenever the value changes? In this situation, Final Salary would be calculated at record creation (each month) and then stay the same regardless of changes in Base Salary
Thanks for your time and your help! 🙂
