Arithmetic expression has inputs of an invalid type 'Unknown'

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!

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

2 Likes

That did the trick! Thank you :+1: :grinning:

2 Likes