Desire blank output instead of #Divide by Zero

Hi, I am using values from different sheet to calculate duration. However, the other sheet does not have values at all time, it may be blank, 0 or output an error. How can output a blank field when my formula comes across such a field.

current formula that works fine with fields that DO have values:

=AVG(COLLECT({Incident Duration}, {Month}, "December", {Calculations Range 3}, 2022))

Using this same formula, I'd also like to add some "error if" statment that takes into consideration the following values in the other page:

It can be smthg like, If incident duration is blank, then output blank in =AVG(Collect).. field

I attempted this but does not work:

=AVG(COLLECT({Incident Duration}, {Month}, "February", {Calculations Range 3}, 2023, IFERROR({Incident Duration}, " ", " ")))

I want to incorporate the IFERROR within the same AVG(COLLECT) statement above

Find more posts tagged with

Accepted answers

All comments

Anjanesh Vaidya

Hi sshariati,

You can apply IFERROR function as below in your formula.

=IFERROR(AVG(COLLECT({Incident Duration}, {Month}, "December", {Calculations Range 3}, 2022))," ")

Thank you!

Anjanesh Vaidya

sshariati

Thank you! This worked!

How can I add additional months? I'd like to use this formula or entire column and associated months and years that are in other columns

I tried this and it doesn't work:

=IFERROR(AVG(COLLECT({Incident Duration}, {Month}, "November", {Calculations Range 3}, 2021)), (AVG(COLLECT({Incident Duration}, {Month}, "December", {Calculations Range 3}, 2021)))," ")

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.