Arithmetic expression has inputs of an invalid type 'Unknown'

[Lee_Yanez]

Hello,

I’m getting an error message on what I thought was a simple Math expression. I can’t seem to work out what is wrong.

Message - Arithmetic expression ‘([VAT Rate]*[Order Net])’ has inputs of an invalid type ‘Unknown’

Order Net is the sum of a table.
VAT Rate is a option of three VAT rates 0%, 5% & 20%

As usual all help greatly appreciated!

[hru · Accepted solution]

You might need to change the [VAT Rate] column type to enum?

[Lee_Yanez]

That did the trick! Thank you