Incorrect Argument Set

Hae Jong

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. :(

Paul Newcome

Try a MEDIAN/COLLECT combo instead.

Hae Jong

Hi Paul,

Thank you for your help.

Could you please let me know example of formula?

Genevieve P.

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