Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to divide to variables, this syntax is not working.
=Sum($(vSetYTD)Cnt/$(vSetPreviousYearYTD)Cnt))
Alex
Hi Alex: what is Cnt in your formula?
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)
Great...!