AnsweredAssumed Answered

Report Script Count of Found Records

Question asked by arobison1 on Sep 4, 2018
Latest reply on Sep 4, 2018 by arobison1

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".

Outcomes