2 Replies Latest reply: Aug 7, 2017 8:00 AM by Sunny Talwar RSS

    Networkdays with Set Analysis

    Lucas Figueiredo

      Hello,

       

      I need to build a Line Chart showing the percentage of orders received and inserted on the last day, for example: If "Variable A" represents the day that I received the order and "variable B" represents the day when I inserted it, I have to use the networkdays function to know the difference of days between the second variable versus the first one and then I have to make a division where my numerator is the orders inserted in 24h and my denominator includes all orders regardless of whether they are inserted on the first day or not.


      At the moment I have the the following formula which must have some syntax error, if someone could help me it would be great!


      =(count({<(NetWorkDays(Variable A,variable B))={"<=1"}>} Orders)) /

      (count({<(NetWorkDays(Variable A,Variable B))={">=0"}>} Orders))

       

      thank you.