set analysis (date)

[adiarnon]

what wrong in my expression-

sum({<Year_Month={"(Year_Month<year(Today())&num(month(today())))"}>}BudgetCurrentBook_UNIT)

tnx adi

[anbu1984]

Do you want to calculate sum when Year_Month is less than today's Year & Month? Then try this

sum({<Year_Month={"<$(=year(Today())&num(month(today())))"}>}BudgetCurrentBook_UNIT)

[adiarnon · Accepted solution]

tnx!

but i found a solution with a variable and its worked!!

😃