This topic contains 4 replies, has 0 voices, and was last updated by Derek Sachs 7 years, 10 months ago.

  • Author
    Posts
  • #5039 Score: 0

    jprice
    • Contributions: 0
    • Level 1

    Is it possible for me to create a formula in an item field that will calculate the savings between the sales price and base price of an item?

    I’m creating item fields for Coupa and one of the fields is “savings %” I’d like to be able to provide that percentage is applicable, can I do it? if so, how can I call the base price and sales price fields?
    This is a cached copy. Click here to see the original post.

  • #5040 Score: 0

    Derek Sachs
    • Contributions: 0
    • Level 1

    I’m assuming the Sales Price is a custom price level you created. I was able to do this by creating an Item field defaulted/sourced from Saved Search results.

    The Formula(Percent) I used was… ({baseprice} – {pricelevel8})/NULLIF({baseprice},0)

    {pricelevel8} is the custom price level I named “Sale Price”, where the value “8” is the Internal ID of the customer price level record.

    Let me know if this helps.

  • #5041 Score: 0

    jprice
    • Contributions: 0
    • Level 1

    Sales Price is the “Online Price”, going to be using this to pull a product feed carrying the savings %


    Derek Sachs replied on 12/15/2016, 10:49 AM: Replace the {pricelevel8} with {onlineprice}. Let me know if that works for you.

  • #5042 Score: 0

    jprice
    • Contributions: 0
    • Level 1

    Just tried it, the field pulls blank data. Do I need to have the base price in my product feed as well in order for the formula to work?

    the item field has the formula code, “formula” is checked and I unchecked “store value”

  • #5043 Score: 0

    Derek Sachs
    • Contributions: 0
    • Level 1

    I did not do this by entering the formula in a field. I did this via Item Search where there was no criteria, and the only thing under results was Formula (Percent), then set summary type to Maximum, and entered the Formula. I also Sorted by the Formula (percent) and set Internal ID as an Available Filter. I then set the Saved Search on the Custom Item Record.

    If you don’t how to set up a Search to use on the the custom field then the below Suite Answer may prove to be helpful.

    Suite Answer: 31727 – Creating Custom Fields with Values Derived from Summary Search Results.

    Let me know if this helps

You must be logged in to reply to this topic.