3 Replies Latest reply: Mar 11, 2018 11:48 AM by Yeo Poh sai RSS

    How to modify YTD expression to Current month ?

    Yeo Poh sai

      Hi All

      This expression work fine , it display YTD sales target .

      =num(Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales_target/1000)/$(Columndim89))

      I wanted to change the expression to current month sales target.

      I want to display 850

      Hope some one can advise me.

      Paul Yeo