2 Replies Latest reply on Jun 26, 2019 7:57 AM by LaTonya Harrington

    Creating a Calculated Field using Data from Multiple Measures

    LaTonya Harrington

      Hello,

       

      I need to create a calculated field that displays data from Measure field based on the combined data from 2 other measures.

       

      The worksheet references 2 blended data sources.  One data source contains the Quality Metric Name and the Metric percentage.  The other data source contains the Metric Targets.

       

      I need to create a calculated field that displays [Target Value] if the [Seq] = 2 and [Group Name] contains 'Primary' or if [Seq] = 0 and [Group Name] contains 'Specialty'

       

      In the dataset the Target Values are the same when the above criteria is met.  Meaning the Primary target value entered at Seq 2 is the same as Specialty Seq 0.

       

      A sample workbook is attached.

       

      Thank you,

      LaTonya