Global Variable for Increment Line Number – Error Conversion from string "" to type 'Double' is not valid
Patty asked 8 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?
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?
My error is coming from something else in my spreadsheet. I believe these steps are accurate.