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

    SET ANALYSIS yesterday sales with selected day

    mohammed alsoby




      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={"$(vToDate)"}} SALES


      kindly help me to find the Solution for that