This content has been marked as final. Show 6 replies
In a table I have these 3 fields: Salary, time_spent_month and time_spent_month_per_project.
I want firstly find the partial salary corresponding to a project. So I create a new measure with the following formula:
[salary]/[time_spent_month]*[time_spent_month_per_project] => I get the right value in this part.
I create then this formula:
Obviously, by adding up all these partial salary, it must return the value of salary. However, it gets double.
Could you please explain me why and correct me in these formula?
Thank you a lot!