counting the unique records

[Aussie John]

I have a records of an audit of a series of rooms which were visited dozens of times. I would like to report the audit via a variety of categories, such as size, use, day visited. In each of the subsummaries I want to see the number of rooms (in summaries). This table is also linked to a parent table which does list the rooms singularly.

[comment]

The old method:

A newer method (version 13 and higher) would filter a value list of rooms by a sub-summary value of a "List of" summary field and count the remaining values

Edited May 22, 2015 by comment

[Aussie John]

Thanks Comment - the old fashioned method worked but Im not sure I understood the  new method.

[eos]

the  new method.​

Assuming you have a value list of roomIDs, a summary field ”List of“ Audit::id_room, and a sorted found set in the Audit table:

ValueCount ( 
  FilterValues (
    ValueListItems ( Get ( FileName ) ; "Rooms" ) ; 
    GetSummary ( sListOfRoomIDs ; sortField )
  )
)

Edited June 1, 2015 by eos

[Aussie John]

thanks!