getting wrong result in comparing three columns

[AnkurSharma]

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 · Accepted solution]

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