I have run into a challenge with my Get Nth Record. If there is no data to pull in, a ? is placed in the field.

I need to delete the ?. Using a Insert calculated text, If (SPE 2::Amount 1 = "?"; "" ; SPE 2::Amount 1 )

Works in FM but when exported the ? remain.

thanks in advance

Jim

You'll want to wrap the whole GetNthRecord string in a substitute that gets rid of the "?", something like:

Substitute ( YOUR_CALC ; "?" ; "" )