2 Replies Latest reply: Feb 15, 2017 4:02 AM by Royce Tang RSS

    problems with only syntax in expression

      Dear experts,


      I was trying to implement an only function in my expression, but it does not seem to be working. can anyone please help me with this ?

      This problem was also stated in the forum earlier on in that link.


      The expression is as of such


      Sum({$<BDF_Type={"*profit*"}, YEAR =Only({<Year={'2015'}>}Year) >} cash) / Sum({$<BDF_Type={"*revenue*"}, YEAR =Only({<Year={'2015'}>}Year) >} cash)


      I am trying to restrict the year value as it also calls the 2015 from the month field. Cheers


      Kind regards,



      Duplicate values in bar Chart