Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
you can incorporate your other clause in the set analysis itself
something like:
=sum({<BMIYEAR={$(JaarVergelijking},Weeknumber={"<=$(=max(weekday(sysdate))"}>}Total)
you can incorporate your other clause in the set analysis itself
something like:
=sum({<BMIYEAR={$(JaarVergelijking},Weeknumber={"<=$(=max(weekday(sysdate))"}>}Total)
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