Forum Discussion

Natz1995's avatar
Natz1995
Frequent Visitor
7 years ago

Monthly Average Based on Fixed Number

Hi    I need a solution to be able to filter my data to month/year and calculate average based on the number of hours in each month   Example: #of Hours Machine is down by Month / Hours Accumulat...
Need Help
  • Natz1995's avatar
    Natz1995
    Frequent Visitor
    7 years ago

    I got the following error

     

    The following syntax error occurred during parsing: Invalid token, Line 8, Offset 17, #.

     

    Example of my dataset:

     

    Table 1

    Month/Year

    Sum of Hours Down

    2019 01

    13

    2019 02

    27

     

    Table 2

    Month/Year

    # of Hours in a Month

    2019 01

    744

    2019 02

    620

     

    I need the average of the sum of hours down in table 1 based on the # of hours in a month in table 2. I tried the formula you provided but I got a syntax error.