Metric Sheet Calculations for a Dashboard

Sarah Johnston

Evening All,

i'm looking to see how I can add to this formula a rule to not include sales variances of 100%. This shows when I am comparing year over year sales and the site does not have those figures to compare. 

=IFERROR(AVG({Sales Variance}), "")

Many thanks,

Sarah

Paul Newcome

Try using an AVERAGEIF statement along the lines of...

 

=IFERROR(AVERAGEIF({Sales Variance}, <> 1), "")

Sarah Johnston

Thank you! That looked to work!  

Paul Newcome

Happy to help!