Network Days only changes for month and year

[stjernvd]

Hi,

I need an expression where network days only changes if you select a month and year, and ignores all other filters.

Here is my equation:

=NetWorkDays(Min(Month={$(vMonthMinus10)},Year={$(vYearMinus10)}>}Date),Max(Month={$(vMonthMinus10)},Year={$(vYearMinus10)}>}Date))

However, when I select other filters, network days changes, and instead it should remain the same for each month and year, regardless of other filters.

So for example, January 2015 has 22 business days, I want it to always be 22 business day for January 2015 (trade month = Jan and trade year = 2015) regardless of other filters.

How do I set this in my expression?

FYI: vYearMinus10 = 2015 and vMonthMinus10 = January

[sunny_talwar · Accepted solution]

May be this:

=NetWorkDays(Min({1<TradeMonth={$(vMonthMinus10)},TradeYear={$(vYearMinus10)}>}TradeDate),Max({1<TradeMonth={$(vMonthMinus10)},TradeYear={$(vYearMinus10)}>}TradeDate))

[Chanty4u]

NetWorkDays(Min(TradeMonth={$(vMonthMinus10)},TradeYear={">=$(vYearMinus10)}>}TradeDate),Max(TradeMonth={$(vMonthMinus10)},TradeYear={$(vYearMinus10)"}>}TradeDate))

[stjernvd]

it works thank you!:)

[sunny_talwar]

Awesome, I am glad it worked