7 Replies Latest reply: May 17, 2018 7:28 AM by Susovan Ghosh RSS

    Set analysis error

    nareshthavidishetty nareshthavidishetty

      HI,

       

      We have used the below logic to derive previous month sales.

       

      But I'm gettion zero sales when executin the logic.

       

      Logic used: =

       

      num(sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Calendar Date]={"$(=AddMonths(MonthEnd(Max([Calendar Date])),-1))"}>}[# QN Open]),'#,##0')

       

      Note: The data is available on every monthend

       

       

      Thanks