ExecuteSQL calc tweak, please
What I'm trying to do is build a calc to count how many instances of the color, red (in the Value field), occur in a found set when the Phase (field) is equal to "III" (three i's, as in Roman numeral III).
I have this so far but it's not working:
ExecuteSQL ( "
SELECT COUNT (Phase__lxt, Value__lxt)
WHERE Phase__lxt = 'III' and Value__lxt = 'Red'
" ; ": " ; ""
I'm looking at Page 26 of the FM 13 SQL Reference Guide to try to discern how to do this but my brain is kaput. TIA for your help!