Calculated field in reports

[matt.tart]

Is there any way to create a calculated column in a report. I'm trying to generate a report that shows Net Profit off of Quotes as a column in the report.

I tried to do a calculated field on the Quotes, but our our net needs to subtract commission which comes from a field in a separate module. Calculated fields don't let you access other modules. I tried to set a workflow to pass the value to a commission field in the Quote but you apparently cannot pass a field value, you can only assign a hard value in workflows.

So is there anyway to either do a calculated column in a report or pass a value from module to module. We're on demand so trying to do this without any code.

[rafael.q.g@hotmail.com]

When I have to do this I make the follow:
1. Create a task (php file) that when accessed compute the info that you want.
2. Create a custom field in your module to store this computed info.
3. The function create on step 1, should store the value on the field created on step 2.
4. Under admin you can create a scheduler to run each X minutes and access your page resposible for the field calculation.

Then you can use your custom field on reports, and your users will just have to know the computed fields could have at maximum X minutes of delay, which in many cases is not a problem.