2 Replies Latest reply on Mar 28, 2018 4:27 PM by Victor Sanabia

    Join Calculations Limitation; Can you use AND <> to filter out data on a join?

    Victor Sanabia

      Can't find documentation anywhere, just examples of Join Calculations. I have 10.5, I'm just trying to figure out limitations on the the Join Calculations.

       

      For example, can you do DATEPART('month', [Sale Date]) AND [Guitar Brand] <> 'Fender', for one side?

       

      Error message I get "Can't logically AND integer and boolean."

       

      I've also learned you can't create a calculated field and use it in the calculation as well.