How can I set up these custom columns in a query?

[ianwuk]

Hello All.

I have a table I manually populate to calculate sales commission.

It has the following columns.

Number of sales

Comission Rate

List Price

Recieved amount

Company Share

Commission Amount

To work out the company share it is number of sales * list price divided by the comission amount (e.g. 50%)

The remaining amount from the total above is deducted from recieved amount to work out the commission amount.

How can I set up company share and commission amount as custom columns with formulas in my query so it is calculated automatically based upon what data I type in?

Many thanks.

ianwuk

[v-ljerr-msft · Accepted solution]

Hi @ianwuk,

Could you post some sample/mock data with the expected result, so that we can better assist on this issue? 

Regards

[ianwuk]

Hi.

I actually figured it out using an article I found.

Many thanks.