This content has been marked as final. Show 7 replies
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'?