-7 network days calculation syntax

[#1]

Hi i am trying to set an expression to calculate the last seven working days.

I have one key figure - weeklyusage

the syntax i have is as follows, however is incorrect

=sum(networkdays(today()-7), weeklyusage)))

Your help is greatly appreciated.

Best,

Bradley

[alexandros17]

if the field related to time is myDate then

=sum({$ <myDate={'=$(networkdays(today()-7)'}>}), weeklyusage)))

hope it helps

[thomas_skariah]

Hi,

You can use below code.

sum({<date={">=$(=AddMonths(Max(date-6),0))<=$(=Max(date))"}>} Value).

Regards,

Tom

[#4]

Hi Alexandros!

thank you for your tip

unfortunately it is not working to calculate value is still 0.

however the syntax appears to be correct.

[Gysbert_Wassenaar · Accepted solution]

Try sum({$<MyDate={'>=$(firstworkday(today(),7))'}>} weeklyusage)