Calculation of Working Day

[qlikviewaf]

Hi Guys,

as you can see i have this table that calculates:

• the working day
• the total budget for the month selected
• the budget for one day of the month

I would like to add a simple thing, the budget Month-to-date: means that i would like to have Budget for one day * the number of working day based on the Day selected. (For example, selecting the 5th of april, i should have Budget for one day* 3 days, since 2 days are non working)

How i can do this? i tried some formula but without success.

Find attached my QV file.

Thank you!!

[Anil_Babu_Samineni]

Please post the expression for Budget for one day. So then i will offer you better

[tresesco]

May be this?

[Budget for one day]*NetWorkDays(MonthStart(Invoice_Date), Invoice_Date)

[Anil_Babu_Samineni]

May be try this?

WeekDay(DateField) as WeekDay

And Analysis should be like below

Only({<WeekDay -= {'Sat','Sun'}>}[Budget for one day expression])