VI Export Job - Conditional export of two data fields into one column with different verbiage

SOLVED

Running Sage 100 v2018 and have a similar issue that was resolved about 6 months ago..."VI Export Job - Conditional export of two data fields into one column" originally posted by SO1.  My situation is similar with a twist.  I am looking to export data from the AP_OpenInvoice table where the CheckType is either "R" or not "R" then rename the results to either "PAID" or "VOID".  The idea is that if CheckType <> "R" I want the field to populate the word "PAID".  If the CheckType = "R" I want the field to populate the word "VOID".

My first attempt was to add a temp field in column 17 and populate the Default as PAID then, in the Conditional statement, I added AP_OpenInvoice01.CheckType$<>"R".  Then I added a second temp field and used column 17 again but this time I populated the Default as VOID then, in the Conditional statement, I added AP_OpenInvoice01.CheckType$="R".

What I'm finding is that if the CheckType <> "R" column 17 populates the word "PAID", which is what I was hoping for.  However, if the CheckType = "R", column 17 is blank and column 18 populates the word "VOID".  Is there a way to force the second Temp to populate in column 17 or do I need to use a highbred solution similar to the earlier referenced post?

Thank you.