4 Replies Latest reply on Nov 30, 2016 12:10 PM by Norbert Maijoor

    Simple Division Calculation is Stumping Me

    Brittney Parker

      Hi All,

        I am having the hardest time figuring out how to create a very simple division calculation and I'm about to pull my hair out!


      What I am trying to find is the percentage of inactive patients.


      I first determine whether a patient was active or inactive:

      Then I created Active and Inactive measures and then a measure of them combined: (there might be a better way of doing this)


      Then on to what is apparently making me feel like a crazy person:


      When I place this next to the numbers it shows up as NULL

      I have tried not using SUM in the Active and Inactive calculations and then using SUM in the % calculation and it still shows up as NULL. Then I tried not using SUM at all for all calculations, still nothing.


      I have no clue on how to figure this one out.


      I've attached a workbook and any help would be greatly appreciated!