I need some assistance with this ExecuteSQL Calculation. The last line is where the problem is located. I tried this in the data viewer and it advises a Syntax Error that I have not been able to solve. I do not know if there is a limit on using the GTN & GFN functions or its just a simple " or )?
"SELECT COUNT ("& GFN (PT_Outcome::Type_Call) &")
FROM " & GTN (PT_Outcome::Z_UID) & "
WHERE ("& GFN( PT_Outcome::Type_Call) & ") = 'Cardiac Arrest'
GROUP BY ("& GFN (PT_Outcome::Shift) & ") " ; "" ; "" )