Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
So you can try sum(x)+5*[Volume]
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.
Hi Theoat, if i do that i get some crazy numbers, see the last column on the right below:
So you can try sum(x)+5*[Volume]
that worked! thank you!