Discussions

I am trying to create a query that searches a table for matching [Order] (fid 8) and then sums the field [Total Amount Claimed] (fid 250) from the found results. I haven't been able to get anything to work and wonder if it is because neither are manual entry fields. Order is rich text formula field and Total Amount Claimed is a formula currency field. 

Any help would be appreciated.

Not tested, but try this  

var text QUERY = 
  "{8.EX." & [Order] & "}";

SumValues(GetRecords($QUERY,[_DBID_MYTABLE]),250)

I am trying to create a query that searches a table for matching [Order] (fid 8) and then sums the field [Total Amount Claimed] (fid 250) from the found results. I haven't been able to get anything to work and wonder if it is because neither are manual entry fields. Order is rich text formula field and Total Amount Claimed is a formula currency field. 

Any help would be appreciated.