I have an ER Report that is working fine with the following filter on a record
Filter(TableRecords.DirPartyLocation,TableRecords.DirPartyLocation.PostalAddressRoles="Remit to")
but I need to change the filter to show the record that contains the value "Remit to" and not where it is = (Equal)
I have tried the following but it returns an error
Filter(TableRecords.DirPartyLocation, Contains(TableRecords.DirPartyLocation.PostalAddressRoles,"Remit to"))
Hi Sophs@4Sight,
I dont think that you use contain function for LogisticsLocationRoleType Enum type.
You can try with OR function to check it helps:
WHERE(Tables.DirPartyLocation
, OR(Tables.DirPartyLocationT.PostalAddressRoles="Invoice", Tables.DirPartyLocationT.PostalAddressRoles="RemitTo"))
Hi Alireza
Our ER report needs to print two different addresses on the report.
The first address selects from the customer addresses where the Purpose = 'Invoice' and the second address selects from the customer addresses where the Purpose = 'Remit to'.
The problem is if we use Filter with = 'Invoice'. The purpose field can have multiple Purposes. So the field's value for Purpose contains 'Business;Invoice;Remit to'. If I try to find records where it is = 'Invoice' it wont find the address. I need to find where Purpose contains 'Invoice'.
Thank you
Hi Sophs,
Can you elaborate that why you need to use contain function?
Can you fulfil this with and/or function also?
Good day Alireza
On the report it is working fine with the following filter on a record
Filter(TableRecords.DirPartyLocation,TableRecords.DirPartyLocation.PostalAddressRoles="Remit to")
but I need to change the filter to show the record that contains the value "Remit to" and not where it is = (Equal)
I have tried the following, but it returns an error.
Filter(TableRecords.DirPartyLocation, Contains(TableRecords.DirPartyLocation.PostalAddressRoles,"Remit to"))
also tried:
WHERE(TableRecords.DirPartyLocation,(CONTAINS(TableRecords.DirPartyLocation.PostalAddressRoles,"Remit to")))
this query does not give a validation error on the formula designer but gives an error at runtime: "Filtering is not supported. Validate the configuration to get more details about this".
Thank you.
Hi Sophs.
Please try to use Where function instead of Filter.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156