Hi All,

I have a question where I need to calculate the accrued value of an amount field. The value has to be calculated without taking the grouping into consideration.

TABLE FILE CAR
PRINT
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY
ON TABLE NOTOTAL
END


In the above mentioned code, I need a new filed which calculates the sum of retail_cost at every row and not take the grouping into consideration.
Unfortunately my code has a few levels of grouping which cannot be done with.
I have used the LAST function but unable to achieve what is needed.

Thanks for looking into it.

This message has been edited. Last edited by: sumant,

TRy this

TABLE FILE CAR
PRINT
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY
ON TABLE SUB-TOTAL RETAIL_COST
END
-* File car.fex

Hello RSquared,

That was not what I was looking for.
I will try to explain it better.

I need the value of retail_cost summed up at every line with the previous value.
For e.g the first value is 8878, then the second row should be 8878+13491, the third be 8878+13491+17850 and hence forth.
The values should keep on adding till the end without being disturbed by the grouping levels.

Sumant,
Did you try:

  
TABLE FILE CAR
PRINT 
 CAR.COMP.CAR
 CAR.CARREC.MODEL
 CAR.BODY.DEALER_COST
 CAR.BODY.RETAIL_COST
 COMPUTE ACC_COST/D7=LAST ACC_COST + RETAIL_COST;
BY CAR.ORIGIN.COUNTRY
ON TABLE NOTOTAL
END

Thanks Danny for the suggestion.

I achieved what I wanted by the following also:

I tried the following and it worked.

TABLE FILE CAR
SUM SALES
COMPUTE CUM_SALES/D12 = CUM_SALES + SALES;
COMPUTE CUM_SALES_2/D12 = LAST CUM_SALES_2 + SALES;
BY CAR.ORIGIN.COUNTRY

Now we are talking!

Please change the topic´s subject to SOLVED.

This message has been edited. Last edited by: Ricardo Augusto,