5 Replies Latest reply on Jul 20, 2018 8:56 AM by Ankit Bansal

    Select one value instead of adding

    Jennifer Gaskill

      Using the attached file. Some states have values for multiple populations (ex: Alabama & Iowa for Adolescent Well-Care Visit Ages 12-21). I need a calc that says "If the state has a score for Medicaid & CHIP use it, if not then if it has a score for Medicaid only use it, if not then if it has a score for CHIP only use it." So in the attached dashboard, the value for Alabama should be 42.2 instead of 74.1 (adding Medicaid Only & CHIP only).