AnsweredAssumed Answered

ExecuteSQL calc tweak, please

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

Title

ExecuteSQL calc tweak, please

Post

Hallo:

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!

Outcomes