Calculate between Two selected dates

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Calculate between Two selected dates

    I am stuck at a place here in my report. Please let me know if I am heading in correct direction. Here a user selects start and end date and based on that it should populate the number on the committed order+Back order column.

    I am using start date as @varStart and end as @varEnd. I want to sum the numbers in between two selected dates. for example- SO(sales order) arriving at different dates in between two selected dates and i want to sum all the numbers.example- based on the input dates in picture, if the SO arrives at 15 feb= quantity 1000, 20 feb-quantity 2200, 21 march- quantity-3000, 1 apr-quantity 1000 etc etc.., it should sum the numbers (all quantities)
    What kind of formula will I use ?I searched for a function and I got SUMIF, but it selected a range whereas I have a I am confused and Item list is a dynarange. My cube structure is- DAY, MEASURE(quantity), LOCATION, CUSTOMER, ITEM.
    • Stock.PNG

      (10.59 kB, downloaded 157 times, last: )
  • You can do this by getting a list of all date elements you need (15 feb, 20 feb, 21 march ...), with a subset formula in namemanager. So that you have it as an array.
    That namerange you can use then as date coordinate for a palo.datav formula.
    Last step ist to put this palo.datav formula in a sum() formula.

    However do not use more then one or two coordinates as named ranges (arrays) with palo.datav :)