cancel
Showing results for
Did you mean:
Helper I

## Struggling closing/writing IF statement :(

Hello community,

I am struggling closing an IF statement, it's almost done but there is something else I need to do.

Basically when the if statement is calculated, I just want to in casa the result is -1, to give me a 0, else give me the result of the IF statement.

I tried to do a nested IF statement:    IF( IF ( ...normal statement) = -1, 0 )  but it's not working. Doesn't give me back the results of the inside IF statement when it's not -1.

Any thoughts???

I have attached a screenshot of the IF statement and the result.

Thank you so much,
Manu

1 ACCEPTED SOLUTION
Super User

Hi @ManuApo

Calculate the value first then check if it equals -1 and return the appropriate value

Use this code - note that I haven't typed out the entire CALCULATE. Please supply code as text raher than an image so it doesn't have to be retyped.

``````First answer by UW Timeline =

VAR Res = CALCULATE( SUM('Calendar'[Workday]), .......

RETURN

IF (Res = -1, 0, Res)``````

Regards

Phil

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

2 REPLIES 2
Super User

Hi @ManuApo

Calculate the value first then check if it equals -1 and return the appropriate value

Use this code - note that I haven't typed out the entire CALCULATE. Please supply code as text raher than an image so it doesn't have to be retyped.

``````First answer by UW Timeline =

VAR Res = CALCULATE( SUM('Calendar'[Workday]), .......

RETURN

IF (Res = -1, 0, Res)``````

Regards

Phil

If I helped you, click on the Thumbs Up to give Kudos.

Proud to be a Super User!

Helper I

Thank you so much @PhilipTreacy !!

I dont know how I couldn't think about that one!

Thanks again 🙂
Manu.

Announcements