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

    incorrect % value given

    Royce Tang

      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

       

      Formula/Script:

       

      (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 !