This content is likely not relevant anymore. Try searching or browse recent questions.
-
9/27/19
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
etc

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.
Details
All Replies (1)
10/4/19
I suppose this is a table which has four fields `[Line]`, `[SelleN]`, `[rate]`, `[Quantity]`
1. Create a new field called `[Revenue]`
2. Type the equation to the formula area
` ``â€‹ ``[rate] * [Quantity]`

Is this what you want?

Then if you only what to see the revenue which rate is \$7.50.
1. Go to the setting of the scorecard
`     Include [rate] Equal(=) 0.75`

Then you can only see the revenue of the lines which rate is 0.75

Or just add a filter control button to the dashboard
Last edited 10/4/19
This question is locked and replying has been disabled.
10 characters required
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

Delete post?