Issue on Setting Up Query

[Former Member]

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

[Former Member · Accepted solution]

Dear Elton,

Try this:

SELECT $[$29.0.number\] - $[ordr.U_cost1.number\] - $[ordr.U_cost2.number\]

Thanks,

Gordon

[Former Member · Accepted solution]

Thanks Gordon.

It does work when I assigned the FMS on the UDF - Gross Profit but there is another problem.

When assigning FMS, if I check the option Auto Refresh When Field Changes, I could only select one field.

But what I prefer is whenever the field Document Total or Cost 1 or Cost 2 changes, the result of the Gross Profit whould change. Would it be possible to do so?

Regards

Elton

[Former Member · Accepted solution]

No. You can only select one field for refresh.

[Former Member]

Hi Elton..........

Can you please explain what is Cost1 & Cost2 and whats the base calculation of Gross Profit?

Regards,

Rahul