cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Manuferdi Frequent Visitor
Frequent Visitor

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([Response Tag])>0,0,1)
Status_SLA_Response is whole number

The problem is when [Response Tag] is 0, we get a blank result in the field Status__SLA_Response and we get the value 1 when [Response Tag] is positive ????? Not really the result expected !
What's wrong ?
 
1 ACCEPTED SOLUTION

Accepted Solutions
vanessafvg Super Contributor
Super Contributor

Re: IF statement set numeric value

@Manuferdi  not ideal but can you +0 to the end of it and see if that fixes it?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
9 REPLIES 9
vanessafvg Super Contributor
Super Contributor

Re: IF statement set numeric value

@Manuferdi  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


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
vinaypugalia Regular Visitor
Regular Visitor

Re: IF statement set numeric value

Hello @Manuferdi ,

 

This actually looks wierd. Might need more details though.

In the mean time, please try the below options - 

1.  IF([Response Tag]>0,0,1)

2. IF([Response Tag]<=0,1,0)

 

Hope, this will help!

Tahreem24 Member
Member

Re: IF statement set numeric value

Hi @Manuferdi ,

 

Please try using your expression with out VALUE keyword. I hope it will give you expected result.

Manuferdi Frequent Visitor
Frequent Visitor

Re: IF statement set numeric value

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 Super Contributor
Super Contributor

Re: IF statement set numeric value

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 @Manuferdi 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Manuferdi Frequent Visitor
Frequent Visitor

Re: IF statement set numeric value

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 Smiley Sad

I tried this
Status_SLA_Response =
SWITCH(
[ResponseTag]<0,5,
[ResponseTag]>=0,0,0
)
But same problem, only the 0 value is displayed.
vanessafvg Super Contributor
Super Contributor

Re: IF statement set numeric value

@Manuferdi  and if you open my power bi, does it look correct?  does it show the right  values?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Highlighted
Manuferdi Frequent Visitor
Frequent Visitor

Re: IF statement set numeric value

Yes, it shows the right result but when a click on the Entre key just after the formula, it becomes wrong also.
It seems to be a problem with the IF statement because only the first <value_if_true> is displayed.
If I change to IF([Response Tag]<0,1,0), I get ones and blanks.
With IF([Response Tag]<0,0,1), I get zeros and blanks.

vanessafvg Super Contributor
Super Contributor

Re: IF statement set numeric value

@Manuferdi  not ideal but can you +0 to the end of it and see if that fixes it?


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 109 members 1,574 guests
Please welcome our newest community members: