Forum Discussion
Filtered value doubles values
Hi, I've been facing the issue of double values in my query when i try to calculate sum of hours into projects with names = Administration, Administration HK and CH administration. My query ...
Himanshi0291 you have given or condition, if there are 3 rows of same project name with 3 options, it will sum up all three. it is doing as expected, what you want to achieve? Don't want to sum if the project as all 3 values?
Hi, I want that it should sum up all three if it has all three project names.
But in my case I have noticed since all the three project names have a word "Administration" common in them it is summing it multiple times.
For example, let suppose I want the sum of project named= "Administration" so instead of given me the result 1, it gives me 3 means it is picking the value from rest 2 also as they also have "Administration" in project name, which should not happen. How to fix this, please suggest.