Cannot perform '=' operation on System.Double and System.String

Develop
#1

Hi,

I am using the below formula to get the count from a data table, when the changed the string from “Posted” to “Posted to SAP” as mentioned in the second formula… im facing an error as “Cannot perform ‘=’ operation on System.Double and System.String.”

No Error -------> DT.Select("[SAP Posting Status] = ‘Posted’","").Count

Error ---------> DT.Select("[SAP Posting Status] = ‘Posted to SAP’","").Count

Please help with the above query

#2

Please kindly assist on the above query

#3

I think the error “Cannot perform ‘=’ operation on System.Double and System.String.” generated in another activity, not because of the select statement above.

If your query 1 command has no exception, then query 2 will also have no exception → this is an error that arises elsewhere