Hi. I've got a report that feeds off a query. In that query I generate rows from a child table *similar* to order items from an order. So each row will have an ID that would link it back to the parent table e,g, order number if this was orders and order items. In the report I'm producing grand totals based on the total of all records returned in the query. But I also want to get a unique count e.g. how many *actual orders*. Below is a simple example. My summary report totals would be for each Type, multiply days by cost and days by saving. That's all working fine. But in this example I've got 2 records for ID 1 and 1 each for IDs 2 and 3. So the total count is for unique IDs i.e. 3 in this case. How do I build an expression based on =Count(ID) but for unique values?
ID Type Days Cost Saving 1 A 45 67.89 3.56 1 B 32 8.90 0.00 2 A 56 23.00 2.00 3 A 37 10.00 .98