Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question