11 Replies Latest reply on Feb 22, 2016 1:09 AM by Jonathan Velarde

    Calculation of two different dates - Getting Number of days without displaying the actual dates

    Jonathan Velarde

      Good Day!

       

      Hi Mam/Sir..,

      Just an inquiry about date calculations.

       

      Is it possible to get the number of days between two dates without displaying the actual dates in the worksheet?

      Based on my experience my calculated field was working for the difference between two dates, but it only works if the actual date is display on the worksheet.

       

      Here is my sample output, attached file.

      The date calculation was working fine but i need to display also the dates.

      What I want to my report is compute the Total Amount on the proper PD Days range.

       

      Sample:

      Nb Days is 8

      Total Amount should be placed on the PD 8-14

       

      Nb Days is 18

      Total Amount should be placed on the PD 15-22

       

      Nb Days is 0

      Total Amount should be placed on the PD Current

       

      I just need to sum the Total Amount per PD Days range and no need for me to add subtotals per store.