2 Replies Latest reply on Apr 22, 2013 10:32 AM by philmodjunk

    What Function to use to evaluate line item in portal

    AndrewCohn

      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!