My Stuff
Comments
-
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
-
Hello @"Nairolf", Yes, I am using a summary search at the moment.
-
I did not know that the numerator and the denominator needed an additional SUM() function to wrap each value before proceeding to divide them. Thank you so much for your help.
-
Hello @"Nairolf", I have attempted to recreate the saved search under Items instead. When I attempt to divide Quantity Returned with Quantity Sold formula fields again, the result is an empty column. Is there another way than to use this as the formula for the return rate formula column? (CASE WHEN…
-
Hello @"Nairolf", I am attempting to calculate the return rate of products sold on a per item basis. Field A = Quantity Returned Field B = Quantity Sold In my head, to obtain a return rate, you will need to divide Field A with Field B. For example, I sold 8 apples, and 4 of them returned to me: 4 out of 8 = 4/8 = 1/2 = 0.5…