As the title describes I have a set of data in a compound document that will be used in one report. In a completely set of data I need to use a min value in a computed field. Is it possible to store that value in a parameter so my computed field later on can be

COMPUTE CUSTOM/D12 = &MINPARAM / Field

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

This can be a way from the moment the original value exist in a table/file:

TABLE FILE CAR
SUM MIN.RETAIL_COST AS MINRCST
ON TABLE HOLD AS HLD FORMAT BINARY
END
-RUN
-READFILE HLD

-TYPE &MINRCST

But without knowing how does your value is stored, difficult to gives you correct solution.

Martin

That code does not seem to be setting the variable as desired. That as statement doesn't seem to be transmitting to variable.

TABLE FILE AITRANS
SUM
MIN.Net_Worth AS NETWORTH
WHERE Client_Number = 1111111
ON TABLE HOLD AS HLD FORMAT BINARY
-RUN
0 NUMBER OF RECORDS IN TABLE= 7 LINES= 1
-READFILE HLD
-TYPE
END

The End command is at the wrong place and you must specify what to display (-TYPE)

TABLE FILE AITRANS
SUM MIN.Net_Worth AS NETWORTH
WHERE Client_Number = 1111111
ON TABLE HOLD AS HLD FORMAT BINARY
END
-RUN
-READFILE HLD
-TYPE &NETWORTH

I had the &NETWORTH in my code the variable was just blank in the output code.

Okay so once i added ON TABLE SET ASNAMES ON it worked.

Thank you thank you thank you.

Learn something new everyday with this program.