Simple Average Sum

  • Hi,

    I’m trying to work out how to add 3 numbers together to create an average score.

    Basically I have four fields, label/formula is below. I want the sound, graphics and replay_value to add together and divide by 3 to make an average score.

    My current formula in the score field is…

    sound+graphics+replay_value/3

    sound = 10
    graphics = 10
    replay_value = 10
    score = 23.333333333333332

    How can I make it so the formula would return the score value to be 10 (or whatever the correct average would be if you divide sound+graphics+replay_value)

    Thanks,

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter facelessgaming

    (@facelessgaming)

    I think I may have solved it.

    I needed to put sound+graphics+replay_value in ()

    So (sound+graphics+replay_value) /3 now returns 10

    On another note, how do I make it so that it is one decimal number that returns?

    For example…
    sound = 9
    graphics = 9
    replay_value = 8
    score = 8.666666666666666

    8.6 would be what I would like to return

    Thanks

    Thread Starter facelessgaming

    (@facelessgaming)

    Again not to worry I believe I have solved this.

    round((sound+graphics+replay_value) /3) returns single digit numbers ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Simple Average Sum’ is closed to new replies.