Hello,

For whatever reason when I reference certain fields via compute, the result comes out as "@SUM#112_PAIDAMT" if I just try to reference the field "PAIDAMT". Can anyone advise why the @ sign and all those weird characters display before the field I want to reference?

I'm doing:

TABLE FILE _ADM_STAR
SUM 
	PAIDAMT
ON TABLE HOLD AS 'HOLD' FORMAT SQL_SCRIPT
END 

This message has been edited. Last edited by: Brandon Andrathy,

never mind, I realized you need to reference the entire field name in these kinds of circumstances