52 Replies Latest reply: Aug 27, 2015 11:19 AM by mahathi vucha RSS

    Set expressions for current Quarter and Month sales.

    mahathi vucha

      Hello friends,

      I have a requirement in my project, Where I have to write a set expression to determine current month and current quarter sales

      But the problem is that i have tried so many different expressions and is not able to achieve it.

       

      i have tried it in these ways

      =num(Sum({$<Month = {'$(=Num(month(today()-1)))'}>} [Extended Price] ) ,'$#,###.') keeping in mind that the date in my DB is in Number format. I don't know where and what am i doing wrong. But this is kind of an urgent requirement for me.. Please help.