Issue counting number of topics and sections
I have been requested to produce a report for showing the number of topics, sections and subsections of the standards managed in the platform.
I have defined a statistics report grouping by Source ID and counting the fields Topic ID, Section ID and SubSection ID.
If counted individually (that is counting only one of those elements) the report works out fine but whenever I count Topic IDs along with Section IDs and Subsection IDs, only Topic IDs are counted and the count for the other elements is 0. However when drilling down you go to a report that shows the different Sections or Subsections.
Does anyone have any clue about what is wrong with Archer and how to fix it? I've come up with a work around of creating counting fields in the applications, but I don't think it's a proper solution.