on 2024 Feb 14 3:18 PM
Hello SAC consultants. In an HR model I have a "salary" measure and a "13_salary" measure. The "13_salary" measure is calculated based on the "salary" measure for the month of December, divided by 12. When an employee leaves the company, in months prior to December, I end up having an error in this calculated measure "13_salary". To solve this, I would like to select the last occurrence of the "salary" measure, instead of selecting the occurrence of the "salary" measure in the month of December. It is possible? Do you know any material about this?
Request clarification before answering.
@Former Member
The formula says 13_Salary = Salary_December/12. Where is the salary measure its Salary_December? Do you have Salary measure for each Month ? As a workaround you can create a few extra measures which will ensure you always have a value in December which you can then divide/12.
QuantityLast
QuantityYear: This will always have the last populated period value in December
You can divide this measure for december /12
Br.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
4 | |
4 | |
3 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.