Hello.

I am attempting to multiply two Columns from different modules inside of a Sales Order Report so that I can calculate my net commissions automatically.

Example:

I created a new Sales Order Report with the Sales Order module selected. I also selected the Account, Products, and Deal modules. I selected Tabular Report Type. Under Report Representation, I selected all of my applicable Available Columns. The Columns I'm interested in creating a custom formula column for are:

I need to multiply the Net Total field by my Commission field. I cannot create a formula field for this under the Product or Sales Order module, because the formula requires data from two different modules. 

The objective is to automatically track itemized commission amounts based on converted sales orders.

I do not want to use Zoho Analytics. 

Please, can someone advise how to do this within the Zoho CRM Reports module? I love Zoho so far and will purchase the Enterprise Platform for my entire organization if Zoho can automate this calculation.