Skip to Content
0
May 29, 2020 at 09:10 AM

Subtracting reference to date

34 Views Last edit May 29, 2020 at 09:29 AM 5 rev

Hello,

I am facing a problem of calculate the daily consumption of a given daily reading in Crystal Report:

We have the following data in the database:

DATE          READING

12-Jan         1210
13-Jan         1220
14-Jan         1240
15-Jan         1280

Kindly I need to create a formula to calculate the daily consumption of (READING) between every date and the last date to be:

DATE                 READING            CONSUMPTION

12-Jan                1210                ــــ
13-Jan                1220                10
14-Jan                1240                20
15-Jan                1280                40

Regards...