
Re: Set Analysis for calculating 3 different values
Sunny Talwar Sep 15, 2016 5:06 PM (in response to Cliff Clayman)May be like this:
=Money(Count(DISTINCT {<FY = {$(=vCFY)}, [PurchaseType] = {'ABC', 'DEF', 'XYZ'}>} [PO]) * vPOCostABC,'$#,##0')

Re: Set Analysis for calculating 3 different values
Cliff Clayman Sep 15, 2016 5:09 PM (in response to Sunny Talwar )I failed to mention that there are 3 Cost variables as well that go along with each PurchaseType. Each PurchaseType value has a different cost associated with it.
PurchaseType Cost Variable
ABC vPOCostABC
DEF vPOCostDEF
XYZ vPOCostXYZ

Re: Set Analysis for calculating 3 different values
Sunny Talwar Sep 15, 2016 5:12 PM (in response to Cliff Clayman)Is Purchase Type one of the dimensions? If it is, then you can try this
=Money(Count(DISTINCT {<FY = {$(=vCFY)}, [PurchaseType] = {'ABC', 'DEF', 'XYZ'}>} [PO]) *
Pick(Match([PurchaseType], 'ABC', 'DEF', 'XYZ'), vPOCostABC, vPOCostDEF, vPOCostXYZ)
,'$#,##0')

Re: Set Analysis for calculating 3 different values
Cliff Clayman Sep 15, 2016 5:13 PM (in response to Sunny Talwar )PurchaseType is not a dimension. This expression is just in a text box.

Re: Set Analysis for calculating 3 different values
Sunny Talwar Sep 15, 2016 5:17 PM (in response to Cliff Clayman)Then may be this:
=Money(Sum(Aggr(Count(DISTINCT {<FY = {$(=vCFY)}, [PurchaseType] = {'ABC', 'DEF', 'XYZ'}>} [PO]) *
Pick(Match([PurchaseType], 'ABC', 'DEF', 'XYZ'), vPOCostABC, vPOCostDEF, vPOCostXYZ), PurchaseType))
,'$#,##0')

Re: Set Analysis for calculating 3 different values
Cliff Clayman Sep 15, 2016 5:22 PM (in response to Sunny Talwar )That did it...thanks once again!!!






Re: Set Analysis for calculating 3 different values
neelam sehrawat Sep 15, 2016 5:10 PM (in response to Cliff Clayman)Hey Cliff try this out
Count(Distinct {<FY = {'$(vCFY)'}, [PurchaseType] = {'ABC', 'DEF', 'XYZ'}>} [PO]*vPOCost)
Let me know if it works..