Skip to content
+1-888-319-3663

COMMUNITY FORUM

Global Variable for Increment Line Number – Error Conversion from string "" to type 'Double' is not valid

Patty asked 6 years ago
Global Variables setup:
GBL_LASTREF    default   blank
GBL_LASTSEQ    default   0
RESTRICTION:
If _INVOICE <> GBL_LASTREF then
     GBL_LASTREF = _INVOICE
     GBL_LASTSEQ = 0
End If
GBL_LASTSEQ += 1
return true
CALCULATED FIELD:
dim LineNumber as integer
LineNumber = GBL_LASTSEQ
return LineNumber
WHEN RUN MAP:
Error Conversion from string “” to type ‘Double’ is not valid.
Any idea what I am doing wrong?
Patty replied 6 years ago

My error is coming from something else in my spreadsheet. I believe these steps are accurate.


If you would like to submit an answer or comment, please sign in to the eOne portal.