Button - list all transactions where PO# is null (not there)

[#1]

I have a table listing all the fields for my transactions, including the purchase order number (Field = [Purchase Order]).

I want a button that will cause this table to show only the transactions where there is no purchase order number.

What search string do I use?  I have searched discussion and manuals and cannot find it -or don't understand what I do find 🙂

THANK YOU!

[#2]

The field is [Purchase Order].  Purchase order is loaded into a table called Trxn.  I am viewing the information in a Table object called TB04.

[sunny_talwar]

But you said you want to see transactions which have no purchase order. So, you are not making selection in purchase order, are you? You must be looking to select transactions which don't have a purchase order?

[#4]

The field is [Purchase Order].

It is loaded into a table named Trxn.

I am viewing it in a Table Object designated TB04.

[#5]

I'll send a qvw.

[sunny_talwar]

That might help a lot

[#7]

Here's a mock up.

[sunny_talwar · Accepted solution]

Create a flag in the script

Trxn:

LOAD [Obj Acct],

    [Subsi- diary],

    [Account Description],

    [G/L Date],

    Month,

    Amount,

    [Purchase Order],

    If(Len(Trim([Purchase Order])) = 0, 1, 0) as NullFlag

FROM

[sample_trxn.xlsx]

(ooxml, embedded labels, table is Sheet1);

and then use it like this

[#9]

Thanks!  Works great.