I have a script that runs a report detailing different totals of things in my database. I have it working to show totals for how many schools, students, and courses are being taken. Now I am trying to show how many schools there are with a specific value in their "Stage" field, but I cannot get it to work.
In my script I do this:
Go to Layout [ "(The Layout with this info)" ]
Enter Find Mode ( I set this to find the schools whose "Stage" field has the value "Currently Operating" )
Set Variable [ $$CurrentlyOperating ; Value: Get ( FoundCount ) ]
From here, I return to my report layout and display the values. Yet, only this one is not working. Am I doing these steps in the script wrong?
Instead of reading "33" (which is how many "Currently Operating" schools I have right now), it just displays "1".