Forums › Cached › Customization › Searches / List Views

This topic contains 1 reply, has 0 voices, and was last updated by steven.lacrosse 7 years, 1 month ago.

  • Author
    Posts
  • September 7, 2017 at 11:48 am #22740 Score: 0

    steven.lacrosse
    • Contributions: 0
    • Level 1
    • ☆

    Hey Everyone,

    I'm trying to calculate the margin between an item rate from a transaction and the item's last purchase price for a saved search. I've been getting the dreaded "An error has occurred, click here to notify NetSuite Support" error each time I adjust the formula.

    This is what I've currently tried: sum(100-({item.lastpurchaseprice}/{rate})). The field is Formula (Percentage) and the Summary Type is Sum, any help would be greatly appreciated. BTW, I noticed the Gross Profit option is not enabled in our account, do I need that enabled in order for this to work?

    Thank you,

    Steven
    This is a cached copy. Click here to see the original post.

  • September 7, 2017 at 12:40 pm #22741 Score: 0

    steven.lacrosse
    • Contributions: 0
    • Level 1
    • ☆

    Also, this is being used in a Transaction saved search.

  • Author
    Posts

You must be logged in to reply to this topic.