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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!