Need help in Set Analysis with based on 2 measures or using AGGR()

[pradnya_amol]

Hi All,

Using this formula to get distinct Report IDs in the below table:-

4 : Distinct Report IDs Count: Count(Distinct [Report ID])

1: Distinct Report ID using this Formula: Count(distinct [Report ID]) - Count(distinct{<[Receipts Reviewed]={'Y'}>} [Report ID])

1652 : Expense Amount: Sum([Expense_reimbursement _USD])

540: Requirement: Sum( aggr((Count(distinct [Report ID]) - Count(distinct{<[Receipts Reviewed]={'Y'}>} [Report ID])), [Expense_reimbursement _USD]))  but m getting 90. Please help in creating this formula using either SET analysis or AGGR()

Approver	Distinct Report IDs	Distinct Reports using Main Formula	Expense Amount
Pradnya	4	1	$1652