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

    problems with only syntax in expression

    Royce Tang

      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,

      Royce

       

      Duplicate values in bar Chart