Forum Discussion

cpunnett's avatar
cpunnett
Icon for Helper II rankHelper II
8 years ago

Calculating a variance

I'm trying calculate a variance and need help please.  I'm trying to take submissions from Year 2018 subtract submissions from 2017, then divide that number by submissions from 2017.  My problem is w...
Need Help
cpunnett's avatar
cpunnett
Icon for Helper II rankHelper II
8 years ago

Thanks for the update.  I've tried that and so many other different ways, but the results are always unexpected and just wierd.  For instance, I have this now.  Why would the variance equal the issued sum for 2018?

danextian's avatar
danextian
Icon for Super User rankSuper User
8 years ago

hi cpunnett,

 

Please follow my formula. As mentioned in my previous post, assigning a measure to a variable will make it a constant.