2 Replies Latest reply on Oct 17, 2016 10:27 AM by tanya.kanwar.0

    Issue with date parameter


      Hi, I created a parameter called date parameter which picks all the date from "Order date".

      In my workbook, I want the sales by selected date, selected date -1 and difference. Everything works fine except when

      The logic works fine except when user selects monday. The logic picks up, The date difference (selected date -1) as the same day sales instead of taking sales from Friday(skipping sat & sun). and it fails. How do i correct this ?

      How do I correct this ? I have attached workbook.


      Please help..