BY IN_CUSTNO NOPRINT BY DepartOrder NOPRINT BY IN_DEPARTMENT NOPRINT ---------------------------------------- i think it has to do with the following section ----------------------------------------- SUM COMPUTE gtotbydepcase/I7 = totbydepcase + cITEMS + NOcITEMS; NOPRINT COMPUTE gtotcost/D12.2 = totCost; NOPRINT COMPUTE gtotalprof/D12.2 = totSRP - departcost; NOPRINT COMPUTE gpercentprof/D12.2 = ( totSRP - departcost ) / totSRP * 100; NOPRINT BY IN_CUSTNO
I dont know what this error is or how to fix it
thanks for the help!This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6 Windows, All Outputs
July 07, 2011, 09:44 AM
RSquared
Charles,
This error is caused by the fact that you need to have you multi-verb in a particular sequence. It has to be BY IN_CUSTNO first and then BY IN_CUSTNO BY...
WF 7.6.11 Oracle WebSphere Windows NT-5.2 x86 32bit
July 07, 2011, 10:44 AM
Charles Richards
Ok, but then how would I get those computes to sum by just IN_CUSTNO? If I put in more BY fields it will give me the worng result, i believe
WebFOCUS 7.6 Windows, All Outputs
July 07, 2011, 11:46 AM
RSquared
Unless you are using the fields you computed in the first statements later, just switch the order on the Computes.