Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to divide two variables?

I want to divide to variables, this syntax is not working.

=Sum($(vSetYTD)Cnt/$(vSetPreviousYearYTD)Cnt))

Alex

3 Replies
Not applicable
Author

Hi Alex: what is Cnt in your formula?

Not applicable
Author

Its the column that I'm using. The parens where just in the wrong order. I needed to close the sum on the first expression. This works.

Sum($(vSetYTD)Cnt)-sum($(vSetPreviousYearYTD)Cnt)

Not applicable
Author

Great...!