Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I'm facing one issue with working days.
My calculation like:
=(Sum(sales) / Number of working days in a month) * Number of working days in week
See below image, Monthly working days working fine, but weekly working days not working properly..
Example : 18 week, Monthly working days =23 and Weekly WDays should be 4., but here showing 1.
My Sales2 column should be 375
PFA,
Please can you help Experts!
Why is Week 22 have 5 work days?
Week 19, can be fixed using this
NetWorkDays(Aggr(NODISTINCT MIN(Common_Date), Week), Aggr(NODISTINCT MAX(Common_Date), Week))
May be this
NetWorkDays(MIN(TOTAL <Week> Common_Date), MAX(TOTAL <Week> Common_Date))
Hi Sunny,
Thanks for reply..
18th week we have 4 working days, but 19, 20, 21 have 5 working days,
here showing 4 only, should be 5
My selections are 2018 May
Why is Week 22 have 5 work days?
Week 19, can be fixed using this
NetWorkDays(Aggr(NODISTINCT MIN(Common_Date), Week), Aggr(NODISTINCT MAX(Common_Date), Week))
Excellent Job - Sunny
Hi Sunny,
I need one more help..
I have StaffName, so if StaffName=A, i have to show Budget data.
But, Budget data not in proper way - monthwise data as like below.
I written like: SUM(AGGR(SUM(TOTAL BudgetAmount), Week)),
My data should be Bifurcate week level..
Suppose My JAN month have (W1(5Days), W2(5Days), W3(5Days),W4(5Days), adn W5(3Days))
=Week1 should be
=Week2 should be
=(100/(Number of working days in a month) )* Number of working days in a week
=(100/23)*5
=21.75
=Week3 should be
=(100/(Number of working days in a month) )* Number of working days in a week
=(100/23)*5
=21.75
=Week4 should be
=(100/(Number of working days in a month) )* Number of working days in a week
=(100/23)*5
=21.75
=Week5 should be
=(100/(Number of working days in a month) )* Number of working days in a week
=(100/23)*3
=13.04
Weeks totals (W1 to W5) should be 100
Please can you help me on this....
Please anyone can help on this..!!!
so for StaffName = A, you want to see 21.75 for first 4 weeks and 13.04 for the 5th fifth week when you select Jan?
Yes sunny..
I'm trying with this, but not working properly... by default taking MAX values for all weeks.
AGGR(RangeSum(TOP(TOTAL MAX(ConOpsTarget), 1, Week)), Week)
I think this is a missing data problem... look what happens when I select A...
There is no Week 3 and 4.... in order to fix this... you will need to fill in the missing information