Skip to Content
0
Former Member
Jul 27, 2010 at 09:29 AM

Issue on Setting Up Query

361 Views

Dear Experts

I am confused on setting up a query.

The scenario is as follow:

I have setup 3 UDFs in the title level of Marketing Document (Sales Order) and named it as Cost1, Cost2 and Gross Profit.

I would like a query that could calculate the Gross Profit by assigning a formatted search using the Document Total minus Cost1 minus Cost2 given that the result would change if any of the variables in the formula changes.

Any good suggestions?

Thank you

Regards

Elton