Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi jduenyas
Use like below..
Month(Today())
or
Month(Date(Today()))