[anton8359 Contributions: 0Level 1☆]

Good afternoon,

In Netsuite, we created a custom column for estimated cost in opportunities, we don’t utilize items because for every deal cost changes, In a search I can use sum to total up the amount, costs, as well as gross profit, I can’t get a function to do gross margin, if I do est. cost / amount it will total up the margin for each line (like if one line was 10% and another was 12% search would result in 22%) Need to create a function that takes sums of quantities in multiple lines and divides by sum of quantities in multiple lines. Please Help !! LOL
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC Contributions: 0Level 1☆]

You can use sum() as a function, so you can for example so something like sum({amount})/nullif(sum({quantity}),0) or something like that.

[anton8359 Contributions: 0Level 1☆]

Olivier Gagnon NC — prob should have thought of that … thank you so much !

[Author]

Posts