Forum Discussion

AnkurSharma's avatar
AnkurSharma
Icon for Helper I rankHelper I
3 years ago
Solved

getting wrong result in comparing three columns

Hi,   I am trying to compare three column from diffrent tables, so i am using this Formule    Variance1 = IF(OR('Item Details'[total_cost]=RELATED('22 Nov'[total_cost(22nd Nov)]),'Item Details'[...
  • AilleryO's avatar
    AilleryO
    3 years ago

    Hi,

     

    Just to be sure, did you check if they are exact same type (Fixed Decimal or Decimal ?) ,

    and if they are exactly the same by displaying all digits...

    Hope it helps...

AilleryO's avatar
AilleryO
Icon for Memorable Member rankMemorable Member
3 years ago

Hi,

 

Just to be sure, did you check if they are exact same type (Fixed Decimal or Decimal ?) ,

and if they are exactly the same by displaying all digits...

Hope it helps...