3 Replies Latest reply: Oct 24, 2016 2:51 PM by Massimo Grossi RSS

    Translating to set analysis

    Liam Hanninen

      If I want to only see sales from Canada I would do this in set analysis:


      sum({<Country={'Canada'}>} Sales)


      similarly (but not ideally) I could do;


      if (Country='Canada', Sales)


      Now if I only want to see sales from this last year (YTD) I might do:


      if( min(%Date)>(today()-365), Sales)


      What is the set analysis equivalent of this?