6 Replies Latest reply: Feb 25, 2016 12:44 PM by Sangram Reddy RSS

    [QLik Sense]Doubled value when adding up partial ones?

    Quyen Tran

      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:

      sum([salary]/[time_spent_month]*[time_spent_month_per_project])


      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!