Struggling closing/writing IF statement :(

[ManuApo]

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

[PhilipTreacy · Accepted solution]

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

[ManuApo]

Thank you so much @PhilipTreacy !! 

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

Thanks again 🙂
Manu.