5 Replies Latest reply on Nov 21, 2016 11:09 PM by Heather Grebe

    How can I translate a WHERE clause for use with calculated fields?

    Heather Grebe

       

      I saw some of the other references to the where clause but none really addressed a case such as this... I cannot attach my workbook due to HIPPA restrictions but I have included a screenshot of the non-sensitive elements for reference.

       

      PAO and NAO are both calculated fields... I need (PAO WHERE Outcome = 1)/(NAO WHERE Outcome = 0) for each level of Val...

       

      Is there a way to do this?