Hi,
I have not shared any data for this but can if it would help,

I have a two column table date , units form this a have a virtual table 
Please Login or Register  to view this content.
and I wanted to use Lastnonblank to get the last date with a Unit value
; the docs info says ;

The column argument can be any of the following:

A reference to any column.
A table with a single column.

so my thought was to delcare the above a a var and use 


Please Login or Register  to view this content.
This gives a reference to a column and [N] to evaluate for blanks,

what did work was ; 

Please Login or Register  to view this content.
But this returns the entire table rather than jut the last date for which I have a value, also I'm giving it a table not a column ? so supprised it works,
So 

Please Login or Register  to view this content.
returns just the date so how can I write this for the summarized table?

Richard