Comparing an Individual Variance to a Group Total Variance

[M_Johnson]

Hi All, 

I am trying to compare a specific % variance, in this case one particular Car Dealer's Year on Year % Variance of retails, to the total regional % variance. Then a basic points based system will be applied if the individual Variance is greater than total regional variance

Some Sample Data is below, any help is much appreciated

[Sebastiaandb · Accepted solution]

Hi @M_Johnson 

Not sure what you're looking for, i assume you want Alteryx to calculate the variances and give the points 🙂 (see attached). If not, let me know, i'm sure we can solve this!

[M_Johnson]

Thats Perfect! Thanks!

[Sebastiaandb]

@M_Johnson No problem! Glad to help! Could you mark my post as the solution so others can see it's solved :-D!