topic Re: Error: the number of arguments is not correct for this function in Project data & BIM

Error: the number of arguments is not correct for this function

kjell syryn — Mon, 15 May 2023 21:01:03 GMT

When creating a Expression with 2 IFS i get the error "the number of arguments is not correct for this function". What dose this mean and how can i solve this

Re: Error: the number of arguments is not correct for this function

Barry Kelly — Tue, 16 May 2023 01:01:25 GMT

Make sure it is following the correct format.

IFS(argument_1, result_1, argument_2, result_2, argument_3, result_3)

You can add as many arguments/results as you want.

Barry.

Re: Error: the number of arguments is not correct for this function

Jimmzs — Tue, 26 Mar 2024 19:26:10 GMT

Hi, I'm getting the same error and I think the syntaxis is ok. Can you help me with this?

Jim

Re: Error: the number of arguments is not correct for this function

Barry Kelly — Thu, 21 Mar 2024 01:47:39 GMT

What happens when you remove the last ... ,0

It is not part of the argument.

Barry.

Re: Error: the number of arguments is not correct for this function

Xandros — Thu, 21 Mar 2024 08:05:15 GMT

As additional information:

if you like to add a result (0 in your expression), if none of the other conditions are met, you can do it by adding a TRUE as last argument:

IFS ( TRANSECTO = "T3", 3, TRANSECTO = "T4", 4, TRANSECTO = "T5", 5, TRUE, 0 )

Re: Error: the number of arguments is not correct for this function

Jimmzs — Thu, 21 Mar 2024 15:40:06 GMT

Thank you so much. Indeed I wanted the "0" as the result if any of the conditions were true.