Hi All,
I have the following table structure in my database:
Customer No. Status Date
123 1 01/01/2016
123 2 01/05/2016
123 3 01/11/2016
123 1 01/15/2016
123 5 01/21/2016
123 3 01/25/2016
I want to be able to calculate the days between when the Status changed from '1' to '3' for a specific customer.
In the example above, the status changed from '1' to '3' twice from 01/01/2016 to 01/11/2016 and then from 01/15/2016 to 01/25/2016.
Hence the days would be 11 + 10 = 21 days.
Will it possible to calculate this using a formula in crystal reports?
Thanks