I’m trying to create a report where I need some anonymous information. For example, I’ve got 4 students, and I want to create a report that shows the grades and calculations. But I don’t want to show the names of each student, but a number: 1, 2, 3, 4. I can use RunningCount to create a list, but I want to make sure this number is the same in this specific report. I might have 4 students in a class, and I’m running a report with multiple classes and multiple students. One student might be in 2 of the classes that I’m running, but not in another. So I can’t have RunningCount restart the count on the class because it would easily end up where number 1 in one class isn’t the same student as number 1 in another.
There isn’t a value like this that I have access to in the Universe at the moment, but it’s something we’re looking into.
I can easily create a list of all students in another report tab, but as far as I’ve seen, there isn’t a way to reference that specifically. Maybe there’s a way to create the formula that uses that context of that formula?
We’re using 4.2, SP 8 Patch 9. Been using this for a bit over a year now, and there is so much more to learn. And tricks that I haven’t found for oddities like this.