I am using Creator 4 if that matters. I am a deluge and zoho creator beginner so I apologize if I use the wrong lingo. I've searched other community requests and thought I had my answer but it isn't working.

I want a running total based on a drop down field. If one option is selected I want that one counted up and if the other is selected, count that up. 

I've tried this script in multiple places but it doesn't result in a count.

Regular_Stay = Room_and_Bed_Registration[TypeofStay == "Regular"].count();

Regular_Stay is a single line field where I want a count to show up. I tried this as a number field as well and it didn't work.

Room_and_Bed_Registration is the form name

TypeofStay is the drop down field

Regular is one of the drop down options

Would this have anything to do with it being a subform? I tried the script on the "TypeofStay" field, "on add" from both forms (the form and the subform).

Bonus points if you can also figure out how to get the count to restart. I want to count up the entries with the drop down selection of "Other" and have that number restart after the "regular" drop down is selected. (They only get x number of "Other" stays between "regular" stays)

Many thanks to anyone who can prevent me from pulling all my hairs out :)