Arithmetic expression has inputs of an invalid type 'Unknown'

AppSheet AppSheet Q&A
1

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!

2X_1_1db280cfa75f8432d4e985d79a0b5b6c36f3d0e1.png
2X_1_1db280cfa75f8432d4e985d79a0b5b6c36f3d0e1.png717×497 30.8 KB

2X_a_af97119ce533eaba67a17596b7d2ec51462c41a0.png
2X_a_af97119ce533eaba67a17596b7d2ec51462c41a0.png774×830 31.5 KB

2X_6_69c14858434b4e759b6bfc6acec08cc02db01c99.png
2X_6_69c14858434b4e759b6bfc6acec08cc02db01c99.png771×791 27 KB

2X_8_8f3bcf9c9b71a2c37b46962d02738f03ae0b61c6.png
2X_8_8f3bcf9c9b71a2c37b46962d02738f03ae0b61c6.png980×255 15.6 KB

2

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

2 Likes
3

That did the trick! Thank you

2 Likes