6 Replies Latest reply on Jan 18, 2015 6:26 PM by danlee

    Calculation problem

    danlee

      Title

      Calculation problem

      Post

      I have a Calculation field that if the number comes up less than 1200 I want 1200 as the number.  Here is the calculation in the field:

      Case ( ActivityLevelPossibleDelete = "Sedentary" ;(1.2 * MeasurementsData 2::BMRCalculator);
      ActivityLevelPossibleDelete = "Lightly Active (1-3 days/week)";(1.375 * MeasurementsData 2::BMRCalculator);
      ActivityLevelPossibleDelete = "Moderate (3-5 days/week)" ;(1.55 * MeasurementsData 2::BMRCalculator);
      ActivityLevelPossibleDelete = "Very Active (6-7 days a week)" ;(1.725 * MeasurementsData 2::BMRCalculator))