calculate expression

[Anonymous]

I have initially this expression

=if(IsNull(GetFieldSelections(Week,'*')),Sum({$<Year={$(=max(Year))}>}[Prix de vente TTC]),Sum({$<Weekyear= {$(=max(Weekyear))}>}[Prix de vente TTC]))

I need  to add to this expression the sum [budget] from today till the end of the year

How to do it ?

[Peter_Cammaert]

Budgets are usually provided per month. How do you want to split the current month's budget from the current date onwards? Based on remaining working days? Based on remaining calendar days? No splitting at all?

Peter

[Anonymous]

No splitting at all.

[Peter_Cammaert]

Something like this (add to the existing expression)?

+ Sum({<Year = {"$(=Year(Today()))"}, Month = {">=$(=Month(Today()))"}>} [Budget])

I did follow your question as stated, but this seems pretty useless to me as you'll be mixing a budget from today onwards with Actuals that possibly belong to a previous year. Is that you intention?