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

    Set analysis error

    nareshthavidishetty nareshthavidishetty



      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