8 Replies Latest reply: Sep 4, 2012 2:58 PM by Roland Kunle RSS

    using a formula variable in set analysis

    Martha Thompson

      Hello,

       

      I am having problems correctly using a formula variable in set analysis.    In my application I have defined:

           Variable:  vPeerGroup

           Value:  only({$<EmpPeerSeq={$(=min(EmpPeerSeq))

       

      The formula for the variable appears to evaluate correctly, I can view the value of the variable in a text box with the formula =$(vPeerGroup)

       

      The value will always be text, not numeric.

       

      I'm trying to use this variable in a set analysis equation and cannot seem to get the syntax correct.

       

      =sum({$<QtrSum_MetricID={B20}, QtrSum_PeerGroup={'$(vPeerGroup)'}>} QtrSum_PA_Count)

       

      I can hard-code a Peer Group name, ie, QtrSum_PeerGroup={'Branch'} and it works fine.   This is my first time using a variable that is defined as a formula -- there must be something I'm missing regarding correct syntax.  

       

      Thanks.