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!
HI Sunny,
Please find the attachment, when i select single month working fine.
If i select couple of months getting wrong result..
If i make more than one month should not club the data...
Please can you have a look...
This almost works... but since week 5 is both in Jan and Feb... it is not able to pull the right value
IF([Staff Name]='A',
(SUM(AGGR(SUM(TOTAL <Month> BudgetAmount), Week, Month)) / NetWorkDays(MonthStart(MIN(Common_Date)), MonthEnd(Max(Common_Date))))
*
NetWorkDays(Aggr(NODISTINCT MIN({<[Staff Name]=>}Common_Date), Week), Aggr(NODISTINCT MAX({<[Staff Name]=>}Common_Date), Week)) ,
SUM(Sales))
Sample application working fine, but my main application not working.
If i select that particular StaffName (ex A) only working fine.
Any idea ?
Did you fix the problem of missing data in your original app?
Yes I did.
Don't know