7 Replies Latest reply: Sep 15, 2016 5:22 PM by Cliff Clayman RSS

    Set Analysis for calculating 3 different values

    Cliff Clayman

      I am trying to get a total cost of purchases by type.  I have 3 types.  Here is the expression that works to get the total for just one type.

       

      =Money(Count(DISTINCT If(FY=vCFY and [PurchaseType] = 'ABC', [PO]))*vPOCostABC,'$#,##0')

       

      How can I change this to Set Analysis and account for two more PurchaseType values of 'DEF' and 'XYZ'?