Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Compare two columns in two different tables

I have two tables. one called purchase request and the other called registration   on the purchase request, i have a column called invoice total. and on the regis table column called Regis total. ...
General Comment
Need Help
Show and Tell
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
2 years ago

Anonymous 

 

How can you identify a Purchase Request in the registratons table?

 

Is there some value in both tables that can be linked?  A Purchase Request number?  Some kind of ID for the record?

 

Phil

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Yes I have a column called Pnumber . and the relation between them is many to many. I always get this error

 

The column 'Logistics Center Report[RETAILTOTAL]' either doesn't exist or doesn't have a relationship to any table available in the current context.

 

First table named Logistic center report and the second called regis

is there anayway to solve this to get true or false when the numbers dosenot match?

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I used this formula

    Compare Totals = IF(RELATED('Logistics Center Report'[RETAIL TOTAL])='REGIS'[REGIS TOTAL],TRUE(),FALSE())
     
    And I got an error
     
    The column 'Logistics Center Report[RETAIL TOTAL]' either doesn't exist or doesn't have a relationship to any table available in the current context.
     
    Not sure what to do