Only Show One Line of Data Depending on Status Column

[Former Member]

Hi Gurus,

I have the ff. task which I need some help with.

I have a table which has a unique ID per entry and depending on the value in the Status Column (i.e. Pending/Approved/Declined), I'd only like to see one entry.

So to clarify, the initial status of an entry is pending, once it has been changed to Approved/Declined, I want to get rid of the Pending line.

How would I write this using VC syntax?

The fields I have to work with are the unique ID field and the actual Status value...

Thanks,

Bim.

[Former Member]

Used an aggregate (MAX/Group By) to resolve this issue, closing it.