Help! Formula Query with multiple conditions.
My query is not returning any value for records that meet the conditions. ToNumber(ToText(GetFieldValues(GetRecords("{86.EX.'"&true&"'}" & "{15.EX.'"&[mhe_type]&"'}", [_DBID_BTS_METRICS]), 10))) I ...
Forum Discussion
{86.EX.'"&true&"'}
Just for clarity, this use of true results in nothing. You'd want to structure it this way: {86.EX.'true'} or as Mark has noted below, 1, since a checkbox field is either 1 or 0.
And if this formula field for this query is numeric, SumValues() is your ticket.