Aging Bucket Formulae

Hi, Can you please take a look at the below string and point the error

The formulae works for all the buckets but for any cell carrying data over 91, it throws as error as INCORRECT ARGUMENT

Please see to it and suggest.

=IF(AND([Ticket Age]@row >= 0, [Ticket Age]@row <= 7), "0-7", IF(AND([Ticket Age]@row >= 8, [Ticket Age]@row <= 14), "8-14", IF(AND([Ticket Age]@row >= 15, [Ticket Age]@row <= 21), "15-21", IF(AND([Ticket Age]@row >= 22, [Ticket Age]@row <= 30), "22-30", IF(AND([Ticket Age]@row >= 31, [Ticket Age]@row <= 45), "31-45", IF(AND([Ticket Age]@row >= 46, [Ticket Age]@row <= 90), "46-90", IF(AND([Ticket Age]@row >= 91, "91+"))))))))

Find more posts tagged with

Accepted answers

All comments

Gaurav Chauhan

Thank you. Meanwhile, I fixed the it. Works now.

=IF(AND([Ticket Age]@row >= 0, [Ticket Age]@row <= 7), "0-7",

IF(AND([Ticket Age]@row >= 8, [Ticket Age]@row <= 14), "8-14",

IF(AND([Ticket Age]@row >= 15, [Ticket Age]@row <= 21), "15-21",

IF(AND([Ticket Age]@row >= 22, [Ticket Age]@row <= 30), "22-30",

IF(AND([Ticket Age]@row >= 31, [Ticket Age]@row <= 45), "31-45",

IF(AND([Ticket Age]@row >= 46, [Ticket Age]@row <= 90), "46-90",

IF([Ticket Age]@row >= 91, "91+")))))))

Andrée Starå

@Gaurav Chauhan

Excellent!

Glad you got it working!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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.