December 15, 200916 yr Newbies I have a portal on "student" layout that lists details of students' applications to schools (drawing from the "applications" table). Each row is one application. One of the fields for each row (application) tells me whether that school accepts materials by email with the value "Y". I want a field that gives the total number of Y's in the portal. I.e., how many of the schools a student is applying to that will take email submissions. Is this possible?
December 15, 200916 yr The simple way: Change that field (let's call it AcceptsEmail) to type Number, with 1 signifying True and 0 or empty meaning False. Then add a calculation field in Students = Sum ( Applications::AcceptsEmail ). The other way: Add a calculation field in Students = ValueCount ( FilterValues ( List ( Applications::AcceptsEmail ) ; "Y" ) )
December 15, 200916 yr I attempted using this in my database and I am not getting any values. Okay I am tackling this from a different angle... so I have decided to use the following calculation: ValueCount (FilterValues (bahus::weekly count; "1")) in bahus I have added a calc field called "weekly count" that uses the WeekOfYearFiscal (Date;1) where each week starts on Sunday. I have the result being TEXT so that the Value count calculation will recognize it when filtering and counting values. in bahus portal I have changed my "Week 1" field to use the ValueCount calculation above. My problem now is that nothing is showing in the Week 1 field. I have tried keeping the value as a number, but that does not work either. To clarify my need. I have a database which shows advisors and when they have used a help desk service. There are several hundred advisors and there are over 25000 incidences where these advisors used help desk throughout the year. I need to have a visible overview of weekly numbers. This requires me to have 52/53 fields representing each week. Any ideas on why it is not working?
Create an account or sign in to comment