This content is likely not relevant anymore. Try searching or browse recent questions.
Calculated Field based on different value vs different salespersons 0 Recommended Answers 1 Reply 2 Upvotes
Hi, I have a table with different lines which each one of them has a different Rate for instance:
Line - SelleN - rate - Quantity
Line 1 : Seller 1 : $1 : 1200
Line 2 : Seller 1 : $7.50 : 5000
Line 3 : Seller 1: $11.01 : 8000
Line 4 : Seller 2: $1 : 9000
Line 5 : Seller 3: $7.50 : 15000
each line has a different volume of products sold and i wish to have a list that calculates the revenue for each one of the lines based on its prices vs sales person.
I found a way by creating 1 field for each price like
$1 = sum(sales)*1
$7.50 = sum(sales)*7.50
And then create 1 scorecard per seller and then
I wish to know if there is a more practical way of doing this type of calculation instead of create 1 different calculated field per rate in order to have this in a table.
This question is locked and replying has been disabled.
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.
Go to the Legal Help page to request content changes for legal reasons.