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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!