3 Replies Latest reply on Mar 2, 2018 2:21 PM by jack.glavosek

    Total Innings Pitched in Decimal format

    jack.glavosek

      I am trying to display the number of innings pitched in a baseball game as a decimal value in this format:  "whole innings pitched.number of outs from partial innings."

      If a player pitches 1 full inning and gets one batter out in the next inning, that value is displayed as 1.1.  If a player pitches 1 full inning and gets two batters out in the next, that value is displayed as 1.2.

      When I add these values together, I'd like to display the total as 3 (three full innings pitched) not 2.3.

       

      Innings Pitched is the raw data.  Actual Innings is a formula that converts partial innings to .33 or .667.

       

      The grand total number of innings pitched in my data set is 35.2 (35 full innings and 2 outs from partial innings.

       

      thanks for the help.