33 Replies Latest reply: Nov 23, 2016 11:34 AM by Linoy Elias RSS

    Set analysis - calculate yesterday's sales

    Linoy Elias

      Hi,

       

      I'm having trouble in calculate yesterday's sales in set analysis.

      The today's sales formula works:

      Sum({<DateNum={"$(=Max(DateNum))"}>} Value)

       

      But yesterday's sales formula does not:

      Sum({<DateNum={"$(=Max(DateNum-1))"}>} Value)

       

      What's wrong?