6 Replies Latest reply: May 23, 2018 8:03 AM by nicolas sinquin RSS

    Error in set modifier ad hoc element list: ',' or ')' expected

    nicolas sinquin

      Hye,

       

      I define a variable :

      Set VSecondeTranche =only(if(aggr(Rank(

      Count(if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1))

              /

          Count(Total if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1))

              ,Revenu_T1)

              ,Revenu_T1)=2,Revenu_T1

                  )

              );

       

      That works fine when i put $(VSecondeTranche) (only 1 value).

       

      But when i try

      sum(

            {$<Revenu_T1 = {'=$(VSecondeTranche) '}

                    >} MNT_NET_COJ_TOT

                )

       

      I've the error message.

       

      Thanks