Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

IF statement set numeric value

I'm having a problem with a if statement. It's seems simple but not or I'm making a mistake. 1 field (whole number) : Response tag The new column is Status_SLA_Response = IF(VALUE([Respons...

vanessafvg
7 years ago
Anonymous not ideal but can you +0 to the end of it and see if that fixes it?

Community Champion

7 years ago

Anonymous what data type is the responsetag?

can you paste some of your data, i have tried to replicate your issue but not coming up with the same problem, wondering if its an underlying issue in your data

Anonymous
Not applicable
7 years ago
Here is a sample of my data

1.
Response target
20/01/2019 16:00:00
Response Stop
27/01/2019 05:05:05
Response Tag : -2095
= IF([ResponseTargetDate]<>BLANK(),DATEDIFF([ResponseTargetDate],[ResponseSLAStoppedDate],MINUTE),0)

Status_SLA_Response: 0
=IF([Response Tag]<0,1,0)

2.
Response target
28/01/2019 16:00:00
Response Stop
28/01/2019 20:31:40
Response Tag : 271
Status_SLA_Response: Blank

Could not find the mistake !
- vanessafvg
  Community Champion
  7 years ago
  i have put your data into a model and am not experiencing what you are
  
  see attached, how does this differ from what you doing Anonymous
  ResponseStatusSLA.pbix44 KB
  - Anonymous
    Not applicable
    7 years ago
    Thx Vanessa,
    
    It's exactly what I'm doing.
    To get the wrong result, I put the cursor to the rigth of the formula
    Status_SLA_Response = IF([ResponseTag]<0,1,0) and click en the Enter key.
    
    0 remains 0 and 1 becomes blank :smileysad:
    
    I tried this
    Status_SLA_Response =
    SWITCH(
    [ResponseTag]<0,5,
    [ResponseTag]>=0,0,0
    )
    But same problem, only the 0 value is displayed.

Related content