Valid sheet cell value becomes #INCORRECT ARGUMENT SET when aggregated into a report

RichardJ

Hi,

I have a formula which displays the correct value at the sheet level

=IF([Date Answered]@row = "", "", (YEAR([Date Answered]@row)))

example output = 2021 or if there isn't a date present the cell would be blank.

However, when I aggregate the sheet rows into a report the cell values show as

#INCORRECT ARGUMENT SET

Can someone help me understand why this error is shown in the report view?

Thanks,

Richard

Find more posts tagged with

Formulas

Reports

Accepted answers

All comments

Genevieve P.

Hi @RichardJ

I'm unable to replicate what you're seeing in the Report, that formula should work.

Do you have it set as a Column Formula?

Try wrapping an IFERROR around the YEAR function, just in case it's causing an error due to text in the date cell, or something similar:

=IF([Date Answered]@row = "", "", (IFERROR(YEAR([Date Answered]@row), "")))

Let me know if this has helped! If not, it would be useful to see a screen capture of your Report (but please block out any sensitive data).

Cheers,

Genevieve

RichardJ

Thanks for the response @Genevieve P.

The Formula is a Column Formula.

The original issue was data related, if the 'Date Answered' was in the format

01/01/18 it would work ok on the sheet and display ok on the Report

01/01/2018 it would work ok on the sheet but display as #INCORRECT ARGUEMENT SET on the report

I've changed the historical data to prevent this.

Thanks

Genevieve P.

Hi @RichardJ

I'm glad you figured out the cause! Thanks for posting your solution.

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.