I have a synonym that has summary data and raw data in the same file. I need to create a report that would compare summary data to the detail data to make sure that both are the same. For instance, sum of Sales $ for each State should be the same as Sales $ reported where State = 'All' . Can define file have computed columns based on some criteria? For instance (this is pseudocode)
ALL_FILTER/I7 = SUM(SALES) WERE STATE EQ 'ALL'
ALL_STATES/I7 = SUM(SALES) WERE STATE NE 'ALL'

I have MSFT SQL background and would have used variables in declare statement, then do the difference. I need to solve this issue in Web Focus though, so your ideas are appreciated.

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

DEFINE FILE table_name
ALL_FILTER/I7 = IF STATE EQ 'ALL' THEN SALES ELSE 0;
ALL_STATES/I7 = IF STATE NE 'ALL' THEN SALES ELSE 0;

TABLE FILE table_name
SUM 
ALL_FILTER
ALL_STATES
END