Forum Discussion

2 Replies

  • Gabry's avatar
    Gabry
    Super User
    2 years ago

    Hello arjuns0028 ,

    not sure what  you mean.

    To calculate the % growth the measure you should use is this:

     

    Measure = (newvalue - oldvalue ) / oldvalue

    then you format this as a percentage

     

    so to put more in your data / tables could look like this:

    % growth=
    divide(Enrol_Count  - calculate (Enrol_Count , SAMEPERIODLASTYEAR(dates)),calculate (Enrol_Count , SAMEPERIODLASTYEAR(dates)))

    let me know if this solve your issue

    • arjuns0028's avatar
      arjuns0028
      Helper I
      2 years ago

      Hi Gary,

      I was able to the Enrolment and Amount but I was unable to get the percentage values. My values of the Enrollment were being displayed correctly but I was getting 0 % in both.
      The columns are BC_Amount and Enrol_Count