Hello everyone.
How can i get last and first value in this situation?
My first value is 162.755 and my last values is 206.077.
I would like show the diference of value in another sheet.
4 answers
Hi Anderson Cornelio
You could create a new calculate field with the following formula:
LOOKUP(SUM([2014]),LAST()) - LOOKUP(SUM([1995]),FIRST()) where, "2104" and "1995" are field names. Hope this helps.
Regards,
Vineeth
