Calculate last week

[Anonymous]

Hi,

there is a short mistake in my formular? Actual week should be calculated new, so i get last week: This Week - 1

Variable: varActualWeekNum = Week(Today())

=sum( {<LastWeekNum = {$(varActualWeekNum-1})>} ANZ_INT_ID_GR)

Regards
Stefan

[luis_pimentel]

Try:

=sum( {<LastWeekNum = {$(varActualWeekNum)-1}>} ANZ_INT_ID_GR)

OR

=sum( {<LastWeekNum = {$($(varActualWeekNum)-1)}>} ANZ_INT_ID_GR)

[Anonymous]

Hi,

thanks for your reply. Last delivery It doesn't work?

[MK_QSL · Accepted solution]

Try this...

=SUM({<LastWeekNum = {'$(=varActualWeekNum-1)'}>}ANZ_INT_ID_GR)