Set Analysis

[dradoikov]

Hello,

I have a problem with following script

=Sum ({$< TXT = {"Sales"}, AccMonth={$(Month1)} > } AccRowsDebitRowSum)


I want to sum all the values that are less than or equal to the variable $ (Month1)

How to do it

[#2 · Accepted solution]

Hi,

try something like this:

=Sum ({$< TXT = {"Sales"}, AccMonth={"<=$(Month1)"} > } AccRowsDebitRowSum)

If it not work upload an example please.

Good luck!

Rainer

[dradoikov]

Works!

Thank you very much

Daniel