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

    Parameter Control Calculation - returning more than one dimension


      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]



      Any tips/help appreciated.