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
MarkShnier__You
Qrew Legend
Qrew Legendare you trying to SUM a numeric valid in field ID 10.
If so, try this
var text QUERY = "{86.EX.1}AND{15.EX.'" & [mhe_type] & "'}";
SumValues(
GetRecords($QUERY, [_DBID_BTS_METRICS]), 10)