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 |