Networkdays issue

[paulwalker]

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!

[paulwalker]

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...

[sunny_talwar]

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))

[paulwalker]

Sample application working fine, but my main application not working.

If i select that particular StaffName (ex A) only working fine.

Any idea ?

[sunny_talwar]

Did you fix the problem of missing data in your original app?

[paulwalker]

Yes I did.

[sunny_talwar]

Don't know