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




      Zahid Rahim