3 Replies Latest reply on Oct 2, 2018 4:19 PM by Shinichiro Murakami

    Calculating Ratio and Median

    Olu Crawford

      Hello everyone,


      I am having trouble trying to calculate the ratio of the total values. In my example below I would like to calculate the ratio of the totals: 31.3 (Aug-18) and 3.0 (FM FTE Value), which would result in 10.4.


      I am also trying to create a calculation for the median of Aug-18 values, which would show 11.7 the median of (6.0, 13.6, 11.7). Thanks for your help and I included the workbook.