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)

       

      or

       

      =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