0 Replies Latest reply: Sep 6, 2017 9:33 AM by zahid Rahim RSS

    Opening Balance to Calculate and Show

    zahid Rahim

      Dear Experts,

       

      I have made an analysis using text and image option and each line showing a different figure from a different qvd. It is also working for applying filter for example JUL-2017 and show figures for the period of Jul-2017. Now i want to add a line showing opening balance for 01-JUL-2017 i mean all transactions less than 01-JUL-2017. What can be the approach.

       

      Details of report are given below:

       

      Year: 2017 Month: Jul

       

      Sales: 100 (for the period of Jul-2017)

      Exp:       50 (for the period of Jul-2017)

       

      Net:        50 (for the period of Jul-2017)

      Opening: 100 (Less than 01-Jul-2017)

      Closing:   150 (For month end Jul-2017)

       

      Now the question is how to effeciently and effectively we can calculate Opening everything below 01-Jul-2017

       

      Regards,

       

      Zahid Rahim