Filter transaction list property by boolean metric

Question

Struggling to figure out how to set up a formula properly. I’m trying to create an IF statement with a condition where it looks at a transaction list property with X dimension and if it matches to a boolean metric list where X dimension is flagged as TRUE then return A otherwise B.

Transaction List = PL_Transactions
Transaction List Property = PL_Transactions.Vendor
Dimension = Vendor
Boolean Data Type Metric w/ 1 Dimension (Vendor) = Draft_Vendors

Best answer by Nathan

Hi,

If you want to do it in the Transaction list.result =

Draft_Vendors[BY constant:PL_Transactions.Vendor]

It’s the equivalent of a LOOKUP

Nathan · Accepted Answer

Hi,If you want to do it in the Transaction list.result =Draft_Vendors[BY constant:PL_Transactions.Vendor]It’s the equivalent of a LOOKUP

Calvin · Answer

Thanks Nathan - that did the trick! I had the metric and the transaction property switched up in my formula.

Filter transaction list property by boolean metric

2 replies

Ask your question here!

Ask your question here!

Not finding what you're looking for?

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded