Calculate the Sum

[#1]

Hello,

i have 3 dates and 3 values. now i want the sum of those values, which are in the interval of 7 weeks of the date.

my example shows it.

Date	Value
16.04.2013	26,84
17.05.2013	48,81
19.06.2013	706,42

7 weeks before 19.6 is only 17.05.2013. So i want the sum of 706,42 and 48.81.

How can i make this? With a if-statement or loop?

Thanks for your  help!

Best regards,

Aylin

[Gysbert_Wassenaar · Accepted solution]

If you make a date from your Date field you can use set analysis expressions. See attached example.

[#3]

Thank you very much Gysbert!

[#4]

Thank you very much Gysbert!

[#5]

Thank you very much Gysbert!

[#6]

Thank you very much!