conversion from string " " to type 'Double' is not valid
Return _PRODUCTNAME & ” – “ & _MONTHLYIMPRESSIONSCALCULATED
Here’s our formula – any suggestions? We get Error in ‘MsGpDestination’. Line ‘taSopLineIvcInsert___E55F45DF-CA20-4FA4-865B-A5D401054F6C’
Parameter ‘Item description’
Parameter set value event.
The message “conversion from string ” ” to type ‘Double’ is not valid” is likely a result of comparing two values that are not related.
In your example, it is likely the calculated field “MONTHLYIMPRESSIONSCALCULATED” and the fact you are comparing it to a string value.
You can use the ToString function to convert the calculated field in both your If statement and the return statement, which should resolve your issue.
If (_MONTHLYIMPRESSIONSCALCULATED.ToString <> ” “) Then
Return _PRODUCTNAME & ” – “ & _MONTHLYIMPRESSIONSCALCULATED.ToString
if _REN_FEESCHEDULE_REN_FEETYPE = “Deposit” then
I have tried ToString on multiple places, but get the same error.
Help and thank you.
Tanya, the reason ToString() doesn’t work for you is because your source column is already considered a string. You have to convert it to a number so you can do maths on it.
return Double.parse(_REN_TOTALPRICE) * .35
return Decimal.parse(_REN_TOTALPRICE) * .35
both statements will give you the same result.
If you would like to submit an answer or comment, please sign in to the eOne portal.