Comparing the value with another column (e.g., [_THIS] > [ColumnA])

Hi

I am facing an error to compare two fields. One filed is “Quantity” number data type and other filed “Current Stock” (Virtual Column) is list type taken from other table using select().

I want to show error message when the Quantity(Number data type) is greater than or equal to Current Stock(List type).

I tried many ways and showing the error like cannot compare number type with list type and arithmetic error. Please help in this regards. Thanks in Advance

0 8 1,065
8 REPLIES 8
Top Labels in this Space