Sunday, September 16, 2018

Show Price Levels in Columns on Pricing Saved Search

To show Price Levelsas a column on Pricing Saved Searches, perform the following:

  1. List > Search > Saved Searches > New > Pricing > Pricing Search
  2. On Criteria tab and Results subtab, set:
    • Price level - is any of pricelevel1, pricelevel2, pricelevel3, pricelevel4
  3. On Results tab and Columns subtab, set the following:
    • Formula Numeric-- Summary Type = Maximum --- Formula = DECODE({pricelevel},'pricelevel1',{unitprice},'')
    • Formula Numeric-- Summary Type = Maximum --- Formula = DECODE({pricelevel},'pricelevel2',{unitprice},'')
    • Formula Numeric-- Summary Type = Maximum --- Formula = DECODE({pricelevel},'pricelevel3',{unitprice},'')
    • Formula Numeric-- Summary Type = Maximum --- Formula = DECODE({pricelevel},'pricelevel4',{unitprice},'')


Note: Users may attach their case to Enhancement 52389: ShowPrice Level as a column on Saved Searches.

No comments:

Post a Comment