I have a survey database. I've created a field called responses::survey_count. It's using Get (FoundCount) to do some math to get the total number of surveys in the responses table.
survey_count = Get (FoundCount) /14
result type Number.
The Found set has 1694 records out of 4116 total records.
When I use the Data Viewer to verify the result, using the exact same formula, I get the proper result 121. The field is showing 294, which means it's using the Total Record Count to get the result not the number of records in the found set.
Why would this be?