Forum Discussion

daph99's avatar
daph99
New Contributor
4 years ago

Is it possible to convert text to numeric for an account value in a data source?

We are trying to set up a fixed matrix data source that has account values in multiple columns (mix of numeric and text).  Is it possible to convert the text value for an account to a numeric value i...
Data Sources
Koemets's avatar
Koemets
Contributor
4 years ago

I will try to use IsNumeric function of vb.

In Amount column do something like:

if Not isNumeric(api.value) Then 

Return 1

Else

Return api.value

End If

This is oversimplified syntax, so I would suggest to use proper encapsulation for api.value and follow the best MSDN practices.

  • daph99's avatar
    daph99
    New Contributor
    4 years ago

    Thanks...  We were actually able to get it working using the substitution settings.