4 Replies Latest reply: May 23, 2012 6:20 AM by Peter Blokker RSS

    get set analysis formulas to work

    Peter Blokker

      Hi you all,


      I am trying to make this kind of formulas work, but so far without succes. I cant' get them working. Must be something wrong with the syntax but I don't know what. Please give me a push in the right direction.


      =count( {$< Year={"$(Subfield(Concat (Distinct Year, ','), ',' , 1))"}>} IdNumber)




      =sum(  {$< Year={"$(GetFieldSelections('Year'))"} Amount)


      I keep getting zero as an answer while I know  I should be getting numbers far above zero. Where am I going wrong?


      Thanks in advance