Yep, I would use AFIELDS() also. Alan's solution would work for a variable (not null), though.

>Yep, and that one does work in all the cases I mentioned. However, I know AFIELDS will always work because it is not dependent on deriving the decimals based on some value in a field. Alan's solution fails if the value is NULL.
>
>>IIRC, it was suggested to use PADL(FIELDNAME,20) instead of TRANSFORM() in one of previous discussion.