5 Replies Latest reply: Sep 14, 2017 4:29 PM by Fei Xu RSS

    Circular Reference Issue

    Ajinkya Bhonsle

      Hi All,

       

      I have three tables.

      Owner, Opportunity and Checkbook

       

      In the Owner table I have:

      Owner:

      Id as "Opportunity Owner ID",

          User_Theater__c as "User Theater",

          User_Sales_Region__c as "User Sales Region",

       

      In the Opportunity table I have the below script"

      Opportunity:

      OwnerId as "LT Opportunity Owner ID",

          Lookup('User Theater', 'Opportunity Owner ID', [OwnerId],'Owner') as "Region",

       

      In the Checkbook Table:

      Budget:

      Team as "Region".

       

      I want to link the "Region" in Opportunity table with the "Region" in Budget table. When I try to run this I get a circular reference.

       

      How do I resolve this issue?

        • Re: Circular Reference Issue
          Fei Xu

          Can you list all the fields in the three tables please?

            • Re: Circular Reference Issue
              Ajinkya Bhonsle

              Below are the fields:

               

              Owner:

              LOAD

                  Id as "Opportunity Owner ID",

                  User_Theater__c as "User Theater",

                  User_Sales_Region__c as "User Sales Region",

                   User_Sales_Group__c as "User Sales Group"

              FROM [lib://Salesforce QVD/user.qvd]

               

              Opportunity:

              LOAD

                  Id as "LT Opportunity ID",

                  Name as "LT Opportunity Name",

                  OwnerId as "LT Opportunity Owner ID",

                  Amount/(Lookup('CR','IsoCode',[CurrencyIsoCode],'Currency')) as "LT Converted Amount",

                  Date(floor(CloseDate)) as "LT Opportunity Close Date",

                 Lookup('User Theater', 'Opportunity Owner ID', [OwnerId],'Owner') as "LT Theater",

                  Lookup('User Sales Region', 'Opportunity Owner ID', [OwnerId],'Owner') as "LT Region"

              FROM [lib://Salesforce QVD/Opportunity.qvd] (qvd)

               

              Budget:

              Team as "LT Theater",
                  Department,
                  "Year",
                  "Group",
                  Quarter,
                  //concatenate Year and Quarter field
                  [Year] & [Quarter] as "Year Quarter",
                 "Forecast Amount",
                  Activity,   
                  Category,
              FROM [lib://SharePoint - Marketing Finance/Shared Documents\2017 Checkbook Registers\Global\GLOBAL checkbook.xlsx]