5 Replies Latest reply on Oct 1, 2018 8:09 AM by meenu choudhary

    Error in IF Calculated Formula with difference 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

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

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

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

      THEN 'True' ELSE 'False'

      END

       

      but I am getting this error: The calculation contains errors - Syntax error, (maybe you are missing an identifier).

      and last THEN in formula is underscored with has error.

       

      I tried to move / add commas and move / add brackets, but no luck.

      Please advise what should I modify to get valid formula.

       

      Also, is it possible to use "Number of Records"  from 4 different Data Sources in a single view, i.e. combining different Date sources in single view?

      Thanks

       

      Goran