Forum Discussion

kstudsrud's avatar
kstudsrud
Frequent Visitor
7 years ago

Ratio between column values

 

Hi All, 

I am trying to divide each subject by "2017 - Total Population" and "2018 - Total Population" and get the percentage. 

For example in 2017...      2017 05 Asthma / 2017 - Total Patient Population

For example in 2018...      2018-05 Asthma / 2018- Total Patient Population

                                         2018 - 09 Diabete Mellitus / 2018- Total Patient Population
                                          2018 - 11 Hypertension / 2018 - Total Patient Population
                                         etc...

The problem I can't get over is that they are all in the same column "Subject".

I would keep 2017 in one column and 2018 in another.

Any suggestions would be awesome!!

thanks

 

General Comment
Need Help
Tips and Tricks

4 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    Why are they in the same column?  Share the source data.  Share it in a form that can be pasted in Excel.

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi kstudsrud,

    Due to I could not reproduce your data structure, could you please offer your data structure and post your desired result if possibel?

     

    Regards,

    Daniel He

    • kstudsrud's avatar
      kstudsrud
      Frequent Visitor
      7 years ago

       

      Each GUID pertains to a specific patinet. I am trying to take the # of rows that say "2017 05 Asthma" and divide it by the # of rows that say "2017- Total Patient Population". 

      I am trying do do this for all the different measures in the 'Subjuct' column in 2017/2018.