2 Replies Latest reply on Oct 4, 2018 8:14 AM by Goran Kolaric

    Error message: The '=='function can not be applied to the table calculations and fields from multiple data sources.

    Goran Kolaric

      I am trying to create IF formula in Calculated Filed by using fields from 4 different Data Sources

       

      IF

      [O1-COMMERCIAL ACCOUNT INVALID]='True' OR

      [O2-ACCOUNT LE INVALID]='True' OR

      [O3-END USER LE INVALID]='True'OR

      [O4-CHANNEL PARTNER INVALID]='True' OR

      [O5-INTERCOMPANY TYPE INVALID]='True'OR

      [O6-SELLING LE INVALID]='True' OR

      [O7 - no CP]='True' OR

      [O8- Incorrect Forecast]='True' OR

      [O9-Past Due]='True' OR

      [O10 - Owner Inactive]='True' OR

      [O12 - Convertibilty Incorrect]='True' OR

      [O13 - GF Incorrect]='True' OR

      ATTR([ACCOUNTS].[AT1- Name Incorrect characters])= True OR

      ATTR([CONTACTS].[CT1 - Incorrect name NUMBERS & CHARACTERS])= True OR

      ATTR([ACTIVITIES].[AY1-D-Past Due])='True'

       

      THEN 'True' ELSE 'False'

      END

       

      but I am getting this error: The calculation contains errors - The '=='function can not be applied to the table calculations and fields from multiple data sources.

       

      Please advise what should I modify to get a valid formula.

       

      Thanks

      Goran