Operator Type Mismatch error

[ppatane]

I keep getting an operator type mismatch error and I cannot see why.  I have done this before without issue.  I'm sure it is some little thing I am missing.  Here are 2 screenshots: I have tried data types String, V_String, WString, V_WString. 

[Luke_C · Accepted solution]

Hi @ppatane 

Try using ToString([Total Invoice Total VAT])

[ppatane]

Thanks, Luke_C!  That worked!  Can you explain why I had to do that?

[Luke_C]

Hi @ppatane 

Based on the info available, I'd guess that the 'Total Invoice Total VAT' field is numeric. In order to be put into a sentence with other text you would either need to use the ToString formula or update the data type of that field prior to the formula with a select tool. 

[ppatane]

Makes complete sense now...again, grazie signore!