1 Reply Latest reply: Mar 25, 2011 12:12 AM by bandariarun RSS

    Select only future months

    Josh Duenyas

      I am trying to show in a chart only values set for future months (projections). Here is the Expression:

       

      Sum ({$<ESTYR={$(=(only(ESTYR)))},ESTMO={">=$(month(now))"}>}SalesAmount)

      However I get in return all months not only Mar thorogh Dec as I would exect. ESTMO is numeric and so I believe is Month(now())

      Am I doing anything wrong?

      Thanks

      Josh