Networking days non associate data

[paulwalker]

Hi Community,

I'm facing issue with Networkdays non associate data.

My calculation like =(Sum(UnitPrice)/5) * Number of working days in a week

For example Lenin Jeansshorts, this product name have 15.37 unit price..

So my requirement, =(15.37/5) * (weeks)  

have a look below image, for week 1 data not coming, that should be = (15.37/5)* number of working days

Week 1=3.074 * 2   (2, number of working days in Week 1)

=6.14

Week 2=  3.074*5  (5 number of working days in Week 2)

=15.37

and same like Week 1..... to Week 52

Thanks in Advance...!!!

[sunny_talwar]

Try this

(SUM(TOTAL <ProductName>UnitCost)/5)

*

NetWorkDays(MIN(TOTAL <Week> {<ProductName>} OrderDate), MAX(TOTAL <Week> {<ProductName=>} OrderDate))

[paulwalker]

Hi sunny,

Please could you see my expression, not working properly..

IF part not working, else part working fine....

IF(ProductName='Lenin Jeansshorts',

(SUM(AGGR(SUM(TOTAL <Month, ProductName> {<Week=>} Budget), Week, Month, ProductName))

/

NetWorkDays(MonthStart(MIN(OrderDate)), MonthEnd(Max(OrderDate)),  Date#('01/01/2018', 'MM/DD/YYYY'), Date#('03/30/2018', 'MM/DD/YYYY'),

Date#('04/02/2018', 'MM/DD/YYYY'), Date#('05/07/2018', 'MM/DD/YYYY'), Date#('05/28/2018', 'MM/DD/YYYY'), Date#('08/27/2018', 'MM/DD/YYYY'),

Date#('12/25/2018', 'MM/DD/YYYY'), Date#('12/26/2018', 'MM/DD/YYYY')))

*

NetWorkDays(MIN(OrderDate), MAX(OrderDate), Date#('01/01/2018', 'MM/DD/YYYY'), Date#('03/30/2018', 'MM/DD/YYYY'),

Date#('04/02/2018', 'MM/DD/YYYY'), Date#('05/07/2018', 'MM/DD/YYYY'), Date#('05/28/2018', 'MM/DD/YYYY'), Date#('08/27/2018', 'MM/DD/YYYY'),

Date#('12/25/2018', 'MM/DD/YYYY'), Date#('12/26/2018', 'MM/DD/YYYY')),

(SUM(TOTAL <ProductName>UnitCost)/5)

*

NetWorkDays(MIN(TOTAL <Week> {<ProductName>} OrderDate), MAX(TOTAL <Week> {<ProductName=>} OrderDate))

)

PFA,

[sunny_talwar]

Based on selection in Year and Month, there is no Budget value available

[paulwalker]

Hi Sunny,

Thanks for reply..

Budget associating with 2018 and Jan...

My calculation here =SUm(Budget)/No of Working days in a month )* no of working days in a week

example Week 1 = (240/22)*4 =43.

Week2 = (240/22)*5 = 50  and so on...