Forum Discussion

ManuApo's avatar
ManuApo
Icon for Helper II rankHelper II
5 years ago
Solved

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

 

Need Help
Tips and Tricks
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    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

2 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      ManuApo
      Icon for Helper II rankHelper II
      5 years ago

      Thank you so much PhilipTreacy !! 

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

      Thanks again 🙂
      Manu.