4 Replies Latest reply: Jun 19, 2014 3:10 AM by Gerard Bakker RSS

    Variable in Aggr formula

    Gerard Bakker

      Hello community members,

       

      I have a problem with a variable in my aggregation formula:

       

      =Sum(If(Aggr(NODISTINCT Max(DEVEMPDATEKEY,240),SUBDEVICE_ID='2')<=DEVEMPDATEKEY,1,0) * AMOUNT)

      I want a substitute for the part SUBDEVICE_ID='2' into a variable:  {<SUBDEVICE_ID={"$(vDevIdStation1)"}>}

       

      Please help me with the syntax.

      Many thanks, Gerard.