Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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")   Differe...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi skanchan,

     

    I have reproduced your issue.

     

    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

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi skanchan,

 

I have reproduced your issue.

 

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-yuta-msftSpot On :)

 

Thanks