Get a found count of only those records with data in

Discussion created by Stu412 on Jun 28, 2018
Latest reply on Jun 29, 2018 by jrenfrew

Hi there


I can use Get(Found Count) to return a value of all the results on screen, say 93.


What I want to be able to do next is get a value of those results which have a value in a certain field within this found set.  The found set is date driven and the field I wish to count is a calculation, therefore if I modify the Find parameters, the calculation results change, as does the quantity of records.


So in summary, from a Found Set of 93, 30 records in a calculated field are 'not empty' and I wish to pass '30' into a variable in a script.


Thanks in advance