Metric Sheet Calculations for a Dashboard

Sarah Johnston · 09/02/19

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 · 09/03/19

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

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

Sarah Johnston · 09/03/19

Thank you! That looked to work!

Paul Newcome · 09/04/19

Happy to help!

Metric Sheet Calculations for a Dashboard

Comments

Help Article Resources

Categories