set analysis problem

[adiarnon]

whats wrong in this expression:

Sum({<Month={'<=month(today())'}>}Target_Product)

i want the sum of Target_Product till the end of the month

tnx.

[PrashantSangle]

Hi,

Looks like you are missing = in expression

Sum({<Month={"<=$(=Month(Today()))"}>}Target_Product)

[#3]

There are several syntaxes to test. See above all threads and their explanations

Fabrice

[sunilkumarqv · Accepted solution]

Try this sorry for previous one

=Sum({<Month={"=(Month>(Month(today())))"}>}Target_Product)