2 Replies Latest reply on Aug 11, 2014 8:12 AM by philmodjunk

    Filter value help... brain cramping*

    ericjlindholm

      Title

      Filter value help... brain cramping*

      Post

           I THOUGHT i was close on this one but I could b way off.  

           I have an equipment list table.  It is related to many line items.  If a line item is modified after the list is confirmed, I have a script that marks a the field    line item::Flag = "Flag".  

           I have a calculation field(equipment list::Flag) in the equipment list table that I want to return the word "Flag" if any of the related line items have the value "Flag" in the field line items::Flag.  

            

           Right now my calculation field is as follows but it does not return any text:

           equipment list::Flag = If(not IsEmpty(FilterValues (  Line Items::flag;"Flag" ));"Flag")