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...