Hey guys, does anyone know what is wrong with my e...
# generali
Isabella
12/08/2021, 5:56 PMHey guys, does anyone know what is wrong with my expression? Case when (ABS({quantity})-nvl({quantitycommitted})-nvl({quantityfulfilled}),0) = 0 then 0 else 1 end
e
Eric B
12/08/2021, 6:43 PMThis is missing the default value if it’s null — nvl({quantitycommitted})
Eric B
12/08/2021, 6:43 PMshould be nvl({quantitycommitted}, 0)
i
Isabella
12/08/2021, 8:56 PMgot it, now the expression error is gone
Isabella
12/08/2021, 8:56 PMbut its telling me I have a field that doesnt exist
Isabella
12/08/2021, 8:56 PMthis is a transaction search and those three fields definitely exist
l
Luis
12/09/2021, 4:55 AMI'm not on my computer right now but are you sure it's {quantityfulfilled}? I think it's something else if I'm not mistaken.
b
battk
12/09/2021, 5:21 AMguessing ids is a losing game. Use the formula popup for a select of the columns available to a search
battk
12/09/2021, 5:22 AMthey dont always have the same names or ids as records
2 Views