15 Replies Latest reply: Aug 16, 2013 5:28 AM by PAUL YEO RSS

    U R G E N T - Set Analysis Help required

    vikas mahajan

      Dear All

       

      I have following expression for calculating sales as per user selected month and year ,

       

      I want to display same set of expression for last year as per user selected month and year  dynamically.

       

       

      (SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Sales Invoice Qty])

      -

      SUM({$<FiscalYear={$(=max(FiscalYear))}>}[Sales Return Qty])

      )/1000

       

       

       

      Thanks in advance

       

      Vikas