Set the field's storage type to “Unstored”.
btw, to get a record count, you can simply use
ExecuteSQL ( "
SELECT COUNT (*)
WHERE \"StatusExpiry\" = 'Active'
" ; "" ; ""
Thank you! That worked perfectly.
I had the field type set to global as I was trying to duplicate a field from a filemaker starter solution. I wonder why there's would work as a global field and mine would not.
Field (Global): Total for invoices in fm13 invoices starter solution
( [ month = Company Dashboard::Current Month ; year = Company Dashboard::Current Year ; status = Status Filter ; decimal = Left ( Evaluate ( 1/2 ) ; 1 ) ; SQL = ExecuteSQL ( " SELECT SUM ( a.\"Total\" ) FROM \"Invoices\" a " & If ( IsEmpty ( status ) ; "WHERE a.\"Month\" = ? AND a.\"Year\" = ? AND a.\"Status Order\" IN ( 0 ,1, 2 ) " ; "WHERE a.\"Month\" = ? AND a.\"Year\" = ? AND a.\"Status Order\" = ? " ) ; "" ; "" ; month ; year ; status ) ] ; If ( SQL ; Substitute ( SQL; "." ; decimal ) ; 0 ) )
I wonder why there's [sic] would work as a global field and mine would not.
Because their calculation references database fields in its native Filemaker part, which your calc doesn't.
Is this the way the calc is formatted originally in the Starter solution? That's barely readable …
Haha, yep. straight copy and past.
Thanks for your help once again erolst. Much appreciated.