4 Replies Latest reply on Sep 15, 2020 4:30 AM by Joseph_

# How to I persist the percentage calculation on the Totals row?

I am updating my Saved Search so that the totals row can still perform percentage properly.

Currently, the totals row is still blindly coming up with the SUM of the rows above it. This is incorrect and not actually practical in this context for the formula (percent) field type.

Ideally, it is supposed to be Total Qty Returned divided by Total Qty Sold.

My vague idea was to update the formula field by applying a CASE WHEN the row is identified or marked as a total, THEN perform the ideal division of the two mentioned columns.

When I made my attempt on this solution, I tried the % total function, but the numbers at the bottom is not supposed to be 100%.

In practice, I don't think formulas were designed to execute this idea. It is looking closer to a Suitelet solution to substitute the totals row value with a custom-made one.

Unfortunately, using Suitelet to complicate a seemingly simle solution is not my given objective.

Goal: Update the current saved search to make total percent perform the division as did the above rows.

Purpose: So that users of the saved search can discover out of all of a particular filtered criteria, what the percentage of rotten apples are green that are returned and to determine whether other colours (when a criteria is introduced) of apples needs to be thrown out too or be kept in store.

Is there a workaround solution to this?

Thanks in advance.

• ###### 1. Re: How to I persist the percentage calculation on the Totals row?

Hey Joseph,

Not a perfect solution I will give you, but did you try with having a summary search first and if people want details they can drill down then ? (I did not test on my side).

Good luck!

• ###### 2. Re: How to I persist the percentage calculation on the Totals row?

Hello Nairolf,

Yes, I am using a summary search at the moment.

• ###### 3. Re: How to I persist the percentage calculation on the Totals row?

I see, you want a sum on the sums. I won't be helpful in this one sorry I feel that it's a "bug" from NetSuite here. I mean it's technically not a bug but it's indeed not helpful to add percents this way. I believe Excel would do the same thing.

Maybe you would have to have two saved searches. There are some crazy formulas out there to "join" two results together.

Good luck!

• ###### 4. Re: How to I persist the percentage calculation on the Totals row?

6969 divided by 227674 = 0.03 = 3%.

3+7+3+2+1+3+0+0+0+1+1+1+1+1 = 30 is not ideal for my case

After contacting NetSuite support, this issue has been filed as an Enhancement case:

163996 Ability to have Formula Total at the bottom of the search behave like Apply Formula to Grand Total in Report