Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
drohm002
Creator II
Creator II

Sum up total of measure

Hello, see the last column on the right.  I am trying to add up the 3 rows in that column, the answer should be 7.8+6.07+8.22 = 22.09, but its showing 12.9.  As you can see, i am adding 5 to each row in that column and its doing that properly, but not summing them all up together properly.  How do i fix this?  Thank you for your time!

drohm002_0-1729863916553.png

 

1 Solution

Accepted Solutions
theoat
Partner - Specialist
Partner - Specialist

So you can try sum(x)+5*[Volume]

View solution in original post

4 Replies
theoat
Partner - Specialist
Partner - Specialist

Hey,

The +5 is outside of the parenthesis. You do the sum(x) + 5 and not sum(x+5)

Try to change the place of your +5.

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

drohm002
Creator II
Creator II
Author

Hi Theoat, if i do that i get some crazy numbers, see the last column on the right below:

drohm002_0-1729864760444.png

 

theoat
Partner - Specialist
Partner - Specialist

So you can try sum(x)+5*[Volume]

drohm002
Creator II
Creator II
Author

that worked! thank you!