Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
as you can see i have this table that calculates:
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!!
Please post the expression for Budget for one day. So then i will offer you better
May be this?
[Budget for one day]*NetWorkDays(MonthStart(Invoice_Date), Invoice_Date)
May be try this?
WeekDay(DateField) as WeekDay
And Analysis should be like below
Only({<WeekDay -= {'Sat','Sun'}>}[Budget for one day expression])