Filtering on no error message in Price Method

Hello @phastings,

Reading your current formula, it looks like you are familiar with our legacy evaluation engine which did not have support for the absence of a value. Luckily, it looks like you are using our latest cloud features with the Unified Pricing Engine (UPE) which does! In the UPE, we have native support for and prefer the use of "NULL" for the absence of value, better functions for text modification, and native support for Boolean data types which you will find in the modified formula below. With this formula, you will be able to use the "is empty" and "is not empty" filter criteria in your price list instead of trying to find some placeholder string.

Modified Formula:

IF(
    IS_NULL(TRYINORDER([FINAL_PRICE]), /*Handles the situation that final price is null or errored instead of a placeholder value*/
    NULL(""), /*Intentionally returns a NULL value*/
    JOIN(
        ", ", /*Joins all of the results together when there are more with no trailing commas (,)*/
        IGNORE_NULL, /*Tells the function to not concatenate anything when the IF()s below return NULL*/
        IF( [FINAL_PRICE]>[LIST], "Price > List", NULL("")),
        IF( [FINAL_PRICE]>[STANDARD PRICE], "Price > StdPrice", NULL("")),
        IF( [FINAL_PRICE]<ROUND([COST],2), "Price < Cost", NULL("")),
        IF( [PRICE_OLD], "New SKU", NULL("")) /*Price old can become a Boolean true or false instead of an indicative number */
    ) /*If none of the conditions have a value this will return a NULL so no need to manually check for it*/
)

Thanks for posting!