2 Replies Latest reply on Nov 18, 2014 8:33 AM by WF7A

    ExecuteSQL calc tweak, please



      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!