8 Replies Latest reply on Jan 17, 2017 8:06 AM by mursid rahman

    Calculated Field Doesn't Show Its Value

    mursid rahman

      Hello,

       

      I'm having trouble with calculated field. Basically, I've created 4 calculated fields for my analysis but one of the calculated field doesn't show its value. I really need the help.

       

      List of calculated fields:

       

      1. Avg. VPP (working)

      SUM(number of records) / COUNTD(patient code)

       

      2. H1 VPP (working)

      IF attr(service date month group) == 'H1' THEN Avg. VPP END

       

      3. H2 VPP (working)

      IF attr(service date month group) == 'H2' THEN Avg. VPP END

       

      4. Inflation VPP (not working)

      (H2 VPP - H1 VPP) / H1 VPP

       

      I've tried using sum for calculated field number 4 (Inflation VPP ) but it turned out to be invalid.

      (SUM(H2 VPP) - SUM(H1 VPP)) / SUM(H1VPP)

       

      Screen Shot 01-16-17 at 04.26 PM.PNG

       

      Am I missing something? Or is there any other simpler method for the intended result that I wanted?

       

      Thank you.