What Function to use to evaluate line item in portal
Just a quick question about how I can evaluate a value of multiple numerical line item records on an Order record.
Basically, I am trying to make a calculation for a field in my orders table that says "If the tax rate on any line item is greater than X"
I don't think I can use PatternCount, because that's for text strings, I'm not sure if the List() function would work either.
Basically something like: If FunctionX(orders_Lines::Tax_on_Line) > .05" (meaing if any line item has a tax greater than .05, it affects a value on related order record)
I know this is basic but I just need a hint.