This topic contains 4 replies, has 0 voices, and was last updated by Derek Sachs 7 years, 10 months ago.
-
AuthorPosts
-
December 13, 2016 at 9:40 am #5039
jpriceIs 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. -
December 13, 2016 at 3:53 pm #5040
Derek SachsI’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.
-
December 14, 2016 at 1:00 pm #5041
jpriceSales 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.
-
December 15, 2016 at 12:06 pm #5042
jpriceJust 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”
-
December 30, 2016 at 11:03 am #5043
Derek SachsI 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
-
AuthorPosts
You must be logged in to reply to this topic.