Compare List & Number Type

[MauriceWhelan]

Hi. I have a Quantity Field in an (Inventory Out) Table. When completing the Inventory Out Form I am also pulling in the Current Inventory (from Product Table) of the relevant product for the user. I want to enter a Valid If expression that says the quantity entered by the user is only Valid if it is <= [Current Inventory] but the problem I have is the [Current Inventory] field is a Virtual Column and is a ‘List’ Type so when I enter the Valid IF expression in the Quantity field I am getting an error because I can’t compare a Number and a List. Is there anyway around this so I can implement it this way?

Hope this makes sense.

Any help would be great, thanks.

[Aleksi]

Without knowing your column structure, you could covert that list as number like SUM([VirtualList]) and then compare it with the number.

[MauriceWhelan]

Thank you @Aleksi I will try that