4 Replies Latest reply: Sep 16, 2016 4:30 PM by Benjamin Wildmon RSS

    How to modify set analysis to sum all periods selected?

    Benjamin Wildmon

      Set analysis: Sum({<[Fiscal Period Counter Month] = {"$(=max([Fiscal Period Counter Month]))"}>} [Sales])

       

      This works perfectly for its intended purpose. However, when we make selections it defaults to the Max fiscal period month selected. How do I code it to use max month unless selections are made? I've tried a handful of IF statements but to no avail.

       

      First image: June doesn't have an "EHV" sale so nothing is shown. Second image: Only April and May selected but only May sales are shown.

      Capture.PNG

       

      Capture2.PNG