Skip to Content
avatar image
Former Member

Take specific values of the table

Hi,

I need to take the values of the last column of the week, I mean the number 12 and then divide by the average of all the values in each row.

I tried doing the Max (week) and Count (week), but none works. I tried to filter directly least 12 and not give the same result. I can not do so directly because this week number could change later.

Thanks for the help guys!

Cheers,

Miquel.

Untitled.png (19.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 23, 2015 at 02:50 PM

    Hi,

    try with Last function to display the value of 12.

    =Last([Num])

    Not sure about how are you calculating average but can try with this.

    =Last([Num])/Average(Last([Num]))

    Amit


    Untitled.png (32.6 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Amit,

      The calculation of the average do this:

      = Average ([Body]) ForAll ([Week])

      On your answer, it worked.

      Thank you!

      Cheers,

      Miquel.