1

I am trying to sum values where the week number is less than or equal to the current week. It works if i just want equal to current week but not if i want less than or equal.

This is what I've tried but nothing works.

=Sum({$<Week={"$(<=Week(Today()))"}>}Sales
=Sum({$<Week<={"$(=Week(Today()))"}>}Sales

Hopefully someone can help me. thanks in advance

RobLaw84
  • 175
  • 2
  • 5
  • 18

1 Answers1

2

Hi you need operator (less or equal) in the beginning inside quotes. In dollar expansion $(=expr) you always need equal to evaluate it. Try this:

=Sum({$<Week={"<=$(=Week(Today()))"}>}Sales)
Hubert Dudek
  • 1,666
  • 1
  • 13
  • 21