I need a second eye to review my formula. I keep getting "You've entered too many arguments for this function. I don't see it.

Question

I need a second eye to review my formula. I keep getting "You've entered too many arguments for this function. I don't see it.

MsTima253 25

=IF(OR(is_header, is_empty),"",

IF(is_total,

IF(selected_period="Total Year",

SUM(tracking[Amount] * (tracking[Type]=type) * (YEAR(tracking[Effective Date])=selected_year) ),

SUM(tracking[Amount] * (tracking[Type]=type) * (YEAR(tracking[Effective Date])=selected_year) * (Month(tracking[Effective Date]=selected_period))),

if(selected_period="Total Year",

"cat & total year",

"cat & spec. month")))

Barry Schwarz 3,746

1st IF:

1st arg is OR

2nd arg is 2nd IF

   2nd IF:

       1st arg is is_total

       2nd arg is 3rd IF

             3rd IF:

                    1st arg is selected_period

                    2nd arg is 1st Sum - final ) matches first (

                    3rd arg is 2nd SUM - final ) matches first (

The next character needs to be ) to close out 3rd IF. Since next char is not ), 3rd IF is badly formed.

Aryaman AK 0 Reputation points

2023-08-28T15:18:24.6933333+00:00

i am doing the same tutorial and facing the same issue, accepted answer is giving #####. please help.
Barry Schwarz 3,746 Reputation points

2023-08-28T16:54:25.4333333+00:00

Since you are getting a different result, it is not the same problem. Start a new discussion and show your code. Use copy and paste; do not retype your code.

Accepted answer

0 additional answers

Your answer

Barry Schwarz 3,746 Reputation points

2023-06-26T02:06:37.1966667+00:00

1st IF:

1st arg is OR

2nd arg is 2nd IF

2nd IF: 1st arg is is_total 2nd arg is 3rd IF 3rd IF: 1st arg is selected_period 2nd arg is 1st Sum - final ) matches first ( 3rd arg is 2nd SUM - final ) matches first (

The next character needs to be ) to close out 3rd IF. Since next char is not ), 3rd IF is badly formed.
Aryaman AK 0 Reputation points

2023-08-28T15:18:24.6933333+00:00

i am doing the same tutorial and facing the same issue, accepted answer is giving #####. please help.
Barry Schwarz 3,746 Reputation points

2023-08-28T16:54:25.4333333+00:00

Since you are getting a different result, it is not the same problem. Start a new discussion and show your code. Use copy and paste; do not retype your code.

Answer 1

MOUSSA EL HAJRAOUI 315

HiHiYou can start by putting long expressions in variables, eg.

SUM(

tracking[Amount] * (tracking[Type]=type) * (YEAR(tracking[Effective Date])=selected_year)

)

AND

SUM(

tracking[Amount] * (tracking[Type]=type) * (YEAR(tracking[Effective Date])=selected_year) * (Month(tracking[Effective Date]=selected_period))

)

The rest will be easy.

Can you upload the sheet without data or fake data? It will be easy to debug it.

I hope this helped.

Aryaman AK 0 Reputation points

2023-08-28T15:19:30.68+00:00

https://youtu.be/eKyAOjH3Crk?t=9993 this is where the error is, i have 2019 excel and i'm getting ##### when i employed your fix. please help need it asap. thankyou.

Share via

I need a second eye to review my formula. I keep getting "You've entered too many arguments for this function. I don't see it.

0 additional answers

Your answer