2 Replies Latest reply: Dec 10, 2014 3:11 PM by Anand Chouhan RSS

    Formula with AND

      Hello,

       

      I have a formula

      =Sum( {<BMIYEAR={$(JaarVergelijking)}>} TOTAL )

       

      and i want to have a clause added:

       

      AND weeknumber <= Weeknumber of the sysdate.

       

      How do i add this clause to my formula?

       

      Thx in advance.