Incorrect Argument Set
I'm trying to get median of Days on Q2 and so used formula as below.
But, it's not working with message 'incorrect argument set'. it works in Excel. :(
Answers
-
Try a MEDIAN/COLLECT combo instead.
-
Hi Paul,
Thank you for your help.
Could you please let me know example of formula?
-
Hi @Hae Jong
Here's an example formula structure using MEDIAN and COLLECT together. The COLLECT function is sort of like a "filter"... you set the Column you want to evaluate at the very beginning, then you list out each column and criteria afterwards.
Ex:
=MEDIAN(COLLECT([Column to find Median]:[Column to find Median], [Column 1]:[Column 1], "Criteria 1", [Column 2]:[Column 2], "Criteria 2"))
In your case, something like:
=MEDIAN(COLLECT(Days:Days, Quarter:Quarter, "Q1"))
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!