AnsweredAssumed Answered

What Function to use to evaluate line item in portal

Question asked by AndrewCohn on Apr 19, 2013
Latest reply on Apr 22, 2013 by philmodjunk

Title

What Function to use to evaluate line item in portal

Post

     Hi all,

     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.

     Thanks!

      

Outcomes