5 Replies Latest reply on Jan 22, 2018 10:46 AM by Clair Wyatt

    Calculate Field Error - Circular Reference

    Clair Wyatt

      Here's what I have going on in bullet format:

      • I have 2 dimensions; Consultant-Phone, Consultant-Site combined into one... "Consultant"
      • Have another dimension; "Community name"
      • Attempting to make a filter so the user can switch between "Consultant" & "Community name"
      • Calculated Field created:
        case [ConsultantCommunity]
        when "Consultant" THEN [Consultant]
        when "Community" THEN [Community name]
        END
      • Error code came up: "Field 'ConsultantCommunity' contains a circular reference"

       

      How can I avoid this & make it so the user can switch between "Consultant" & "Community name" dimensions?