I have a GI with the results grid shown below.
Everything works, except the GP% calculation. I started with trying to sum the cost and price on the service order details by service order number. I relate back to the service order to use the “OrderDate” as a filter against “fromdate” and “todate” parameters.
I get the below result from the query.
The difference calculation works. How can I calculate the “Difference/Ext.Price” as the %Profit in the last column?
Regards
Wayne
Best answer by aaghaei
It is ONE of the known limitations of GI. It doesn’t take calculated result to perform math on it. It performs the math on each record before aggregation. What you need is achievable by customization only and creating a projection DAC.
+10It is ONE of the known limitations of GI. It doesn’t take calculated result to perform math on it. It performs the math on each record before aggregation. What you need is achievable by customization only and creating a projection DAC.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
