AnsweredAssumed Answered

ExecuteSQL calc tweak, please

Question asked by WF7A on Nov 17, 2014
Latest reply on Nov 18, 2014 by WF7A


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)
  FROM Main
  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!