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'[total_cost]=RELATED('21 Nov'[total_cost(21st Nov)])),1,0)
 
 
Table 1 Item Details Column (Total cost)
Table 2 21 Nov  Column (Total cost (21st Nov))
Table 3 22 Nov Column (Total cost 22nd Nov)
 
 
 
But some values are same but in formulae it consider it as diffrent and returns 0
 
 

 

 


 

  • 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...

1 Reply

  • 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...