7 Replies Latest reply: Nov 24, 2009 6:49 PM by adrianrichards RSS

    Set Analysis (Excluding Values)

    adrianrichards

       

      =

      Sum({$<[Contract_Type]={"*"}-{"*IAV*"}>}[Invoice_Net])

      I am trying to ammend the formula above to exclude [Call_Type] = {"PM"} as well as contract types of IAV but i do not seem to be able to get the syntax correct.

      To recap I need all records for a selection excluding any contracts with iav in the name and excluding call types PM.

       

      Can anyone give me the correct syntax

       

      Thank you