I have a virtual column [Validation] that returns “Compliant” if the SUM() of the values [Steer] , [Drive], [Tri-Axle1] and [Tri-Axle2] is equal to the [Gross] and the [Gross] is less or equal to the [Gross_Limits]; and returns “Non-Compliant” if the conditions are false.
Below is the expression:
([Combinations] = “BDH”), (LIST([Steer],[Drive],[Tri-Axle1],[Tri-Axle2])),
([Combinations] = “WFC”), (LIST([Steer],[Drive],[Tri-Axle1]))
) = [Gross],
[Gross] <= [Gross_Limits]
The data type for all the columns is Decimal except the VC. (See screenshot)
The problem I came across is with the following case:
The VC returns “Non-Compliant” when I use a value with zero (0) as the first decimal digit.
[Gross] = 43.60
[Gross_Limits] = 44
The VC returns “Compliant” when I round the value to 6.1
The sum of the values is 43.60 for both cases, which equals the [Gross], and it is less than 44, which is the value of [Gross_Limits], so all conditions are true. Is there something I am missing?
Thanks in advance for your help!