10 Replies Latest reply: Dec 28, 2016 7:58 AM by Marcus Augusto RSS

    GetFieldSelections with set analysis

    Siva Dandu

      I am trying to display YTD(Year to Date) which should show the value for "all" the months for the selected year.


      =num(Avg ( {$<Year={"$(=getfieldselections(Year))"}, Month={"*"}>} [S14]) *100)


      It is showing the right value if am selecting only Year.

      If is select any months or quarters, the value is changing. This should not happen.