Skip to Content
Former Member
Sep 08, 2013 at 06:30 PM

Formatted Search based on multiple fields


Good day Experts,

I need a formatted search which will pull through the average price (AVGPrice on OWHS) of an item as the unit price. This only needs to pull through if the BP belongs to a specific property otherwise, it needs to pull through the specific price linked to the BP.

Please advise what the correct syntax would be?

Thanks in advance,