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
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