1 Reply Latest reply on Apr 2, 2012 9:28 AM by Alex Kerin

    Parameter Control Calculation - returning more than one dimension

    dorothygrimes0

      My formula writing is not always the best but I'm unsure whether this can be done...

       

      Below is the current formula I am using which works perfectly for switching view between segment and BU. However, I want to bring in [Country] with BU but after trying various methods of formulas, I can't seem to get it to work. How do I put in some kind of AND statement that on selection of BU, it will return [BU] AND [Country].

       

       

      IF [Choose BU/Segment View] = "Segment" then [Segment]

      ELSE [BU]

      END

       

      Any tips/help appreciated.

       

      Thanks