4 Replies Latest reply: Jan 16, 2017 8:39 AM by mohammed alsoby RSS

    SET ANALYSIS yesterday sales with selected day

    mohammed alsoby

      Gents,

      Greetings,

       

      Looking to use Set Analysis to have a dynamic variable  for date field to retrieve yesterday [of the selected day] sales.

      my Fields are :

      1- TRANSACTION_DATE (For Date)

      2- SALES (For Sales) 

      and I use IF condition for retrieve a specific category of sales already do it.


      I tried many statements some them gave Zero values and some Gave me -

      Sum({$<TRANSACTION_DATE={'MAX(TRANSACTION_DATE) -1'}>}SALES)

      Sum({TRANSACTION_DATE={"$(vToDate)"}} SALES

           

      kindly help me to find the Solution for that