4 Replies Latest reply: Jun 13, 2018 4:03 PM by Paul Walker RSS

    Networking days non associate data

    Paul Walker

      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

      Capture.JPG

       

      Thanks in Advance...!!!

        • Re: Networking days non associate data
          Sunny Talwar

          Try this

           

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

          *

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


          Capture.PNG

            • Re: Networking days non associate data
              Paul Walker

              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,