Hi All,

Previously this is my formula :
if isNull({VW_CTRLSUM.ORIGINAL_TRANSACTION_ID}) then '-'
else {VW_CTRLSUM.ORIGINAL_TRANSACTION_ID}

then the error appear 'String is required' and i changed to :

if isNull({VW_CTRLSUM.ORIGINAL_TRANSACTION_ID}) then '-'
else toText({VW_CTRLSUM.ORIGINAL_TRANSACTION_ID},0)

actually this solved the problem, but the result is 6,211,408.
The result should be in number like 6211408
i've tried to use toNumber but 'String is required' error appeared...

Anyone can help to advise on this? thanks a lot

Thanks DBlank, it works =)