Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Calculate total the commission

Hi all,

I have a CR that populate the DataSet  for sale data with columns as following:

Item | condition | cost

1 | used | 10.00

2 | new | 450.00

3 | refurbished | 200.00

4 | used | 45.00

5 | used | 600.00

6 | new | 65.00

7 | new | 400.00

8 | refurbished | 4500.00

etc...

where sale commission percents such new: 20%; used: 5% and refurbished: 10%.

I like to add a new column name: commission amount is the product of Cost and above percent range, finally count the total of commission amounts in the report. I  am not sure how to code in new formula in order to group by in Condition column, add sub total for it, then grand total. Please help me to get a solution. I really appreciate it. Thanks in advance.

Former Member
Not what you were looking for? View more on this topic or Ask a question