Take specific values of the table

[Former Member]

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.

[amitrathi239 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Amit,

The calculation of the average do this:

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

On your answer, it worked.

Thank you!

Cheers,

Miquel.