6 Replies Latest reply: Jul 6, 2015 1:25 PM by Sunny Talwar RSS

    GetCurrentSelections()

      I am trying to write an IF() that will return a value when a field within a group is selected. So I have something along the lines of whats below. However, the function is returning Sum(Sales) when any field in Annual Analysis is selected, not just 2015 YTD like I want. Any suggestions? Thanks in advance.

       

      =IF(GetCurrentSelections([Annual Analysis]) = '2015 YTD', Sum(Sales)))