This content has been marked as final. Show 6 replies
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)))