Formula with AND

[#1]

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.

[saurabh5 · Accepted solution]

you can incorporate your other clause in the set analysis itself

something like:

=sum({<BMIYEAR={$(JaarVergelijking},Weeknumber={"<=$(=max(weekday(sysdate))"}>}Total)

[its_anandrjs]

Write like

=Sum( {<BMIYEAR={$(JaarVergelijking)}, weeknumber = {'<=$(=Week(sysdate)  )'}     >} TOTAL  FieldName )

Otherwise

=Sum( {<BMIYEAR={$(JaarVergelijking)}, weeknumber = {'<=$(=Week(sysdate)  )'}     >} TOTAL  )

What is TOTAL here let me know

Regards

Anand