Hi,

In infoassist, when I select column totals or subtotal I see two options simple and recomputed. Can someone please tell me the difference between simple and recomputed options?

Regards
BI Dev

This message has been edited. Last edited by: FP Mod Chuck,

If you have a compute with for instance this calculation:

CAR.BODY.DEALER_COST / CAR.BODY.RETAIL_COST * 100

A simple total will sum the result of the calculation, a recompute will perform the compute on total values.

Frans,

Thanks for your response, Let's say I have the below code.
TABLE FILE CAR
SUM CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
COMPUTE Compute_1/D12.2%=((RETAIL_COST-DEALER_COST)/RETAIL_COST) * 100;
BY CAR.ORIGIN.COUNTRY
ON TABLE PCHOLD FORMAT HTML
-* ON TABLE COLUMN-TOTAL
ON TABLE RECOMPUTE
END
are simple total(in GUI) and ON TABLE COLUMN TOTAL and recompute in GUI and ON TABLE RECOMPUTE same?

This message has been edited. Last edited by: BI Dev,

BI Dev

Not sure what you are really asking. When I run this code with RECOMPUTE the value for the compute field is different than when I use COLUMN-TOTAL. The results are what I would expect them to be.