11 Replies Latest reply: Feb 23, 2017 5:12 AM by Sunny Talwar RSS

    incorrect % value given

      Dear experts,


      I am trying to get a % value out of an expression, however I do believe there is some faults with my coding. Below I will provide the expression as well as the logic I am trying to achieve.


      the requirements: (revenue from previous year / revenue this year) - 1




      (Sum({<BDF_Type = {"Revenue"}, [year] = {"$(=Max([year])-1"}>} cash)    /      Sum({<BDF_Type = {"Revenue"}, [year] = {"$(=Max([year])"}>} cash) ) -1


      The individual components of expression work, however when put together to acquire the ratio, they seem to be calculating the wrong values. Cheers !