Excluding Zeros from an Average Formula

Hello,

I am creating a simple dashboard showing the average percent complete for a portfolio of projects. We have now decided to carve out those projects not yet started (0% complete). How do I edit my formula to carve out those projects that are at 0% complete?

=AVERAGEIF({Information Technology Business Plan Range 2}, "Transit Information Program", {Information Technology Business Plan Range 3})

Thanks!

Find more posts tagged with

Accepted answers

All comments

Chris Mondeau

Hi @Stacey Gerhardt!

Here's a couple options for you:

AVERGAGIF() is a good option if there's only one criteria you're trying to meet, like excluding zeros. If you want to exclude more values, then using the AVG() and COLLECT() formulas together can help you get more options.

Let us know if that helps, thanks!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.