Skip to main content

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

Hi,

 

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

Draft_VendorssBY constant:PL_Transactions.Vendor]

It’s the equivalent of a LOOKUP

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

Reply


Ask your question here!

Terms & ConditionsCookie settings