1 Reply Latest reply on Jul 14, 2012 7:33 AM by philmodjunk

    Case Calculation Problem



      Case Calculation Problem


      Novice needs help...

      I have a checkbox field with a series of values and want to have a calcuation that results in a number when specific boxes are checked.  I want a 1 entered when either "Prior Heart Attack" or "Prior Stoke" are checked.  I also want the a 1 entered when both are checked.  Below provides the value when either is selected but not when both are selected.

      Case (MI Health Problems = "Prior Heart Attack"; "1";

      MI Health Problems = "Prior Stroke"; "1";

      MI Health Problems = "Prior Heart Attack" and "Prior Stroke"; "1";



      Thank you in advance for any help...


      Frustratingly yours


        • 1. Re: Case Calculation Problem

          Not IsEmpty ( FilterValues ( MI Health Problems ; List ( "Prior Heart Attack"; "Prior Stroke" ) ) )

          This is a boolean expression that returns either 1 if True or 0 if False. You can look up each of these functions in FileMaker help to learn more.