cancel
Showing results for
Did you mean:
Frequent Visitor

## If Condition issue

Hello Everyone,

I have created a if formula and i am not getting the right result.Below is my if formula

If_Formula = IF((By_Emp[Total_hrs]<By_Emp[Avail_Hrs]),"Missing","Correct")

Difference = By_Emp[Avail_Hrs]-By_Emp[Total_hrs]

If you see the screen shot below, difference is 0. So accordig to my IF formula it shows Missing in last column. I think it should be showing Correct in last column. Am i missing something here?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: If Condition issue

Hi

You are using a table visual like below, right?

See the original table, please check if the length of mantissa in a decimal is more than 2 because the table visual will emit several digits based on your setting which may mislead you.

To see the correct result in table visual, click Modeling->Format->Change the number of decimal places.

Regards,

Jimmy Tao

5 REPLIES 5
Established Member

## Re: If Condition issue

Well I tested the same at my end. Didn't find anything wrong with your formula.

Maybe you can try this If_Formula = IF([Difference]>0,"Missing","Correct") or If_Formula = IF(((By_Emp[Total_hrs]-By_Emp[Avail_Hrs])<0),"Missing","Correct")

Frequent Visitor

## Re: If Condition issue

Strange that it work  at your end.

I dont want to use the difference colume because i created that column just to help troubleshoot the issue.

Established Member

## Re: If Condition issue

@skanchan  Try this If_Formula = IF(((By_Emp[Total_hrs]-By_Emp[Avail_Hrs])<0),"Missing","Correct"), it should work.

Community Support Team

## Re: If Condition issue

Hi

You are using a table visual like below, right?

See the original table, please check if the length of mantissa in a decimal is more than 2 because the table visual will emit several digits based on your setting which may mislead you.

To see the correct result in table visual, click Modeling->Format->Change the number of decimal places.

Regards,

Jimmy Tao

Frequent Visitor

## Re: If Condition issue

@v-yuta-msftSpot On

Thanks