Hello,
In a table for a certain car I've got following fields:
Date Qty. petrol(ltr) Amount (H)Odomtr
2002/04/01 52,2 53,24 15500
2002/04/11 47,4 46,45 16069
2002/04/15 53,4 54,20 16843
2002/04/23 29,3 30,47 17136
2002/05/02 48,4 49,61 17867
2002/05/06 49,6 51,09 18497
In our company we've almost fifty cars. In one Crystal Report ( if possible the CrossTab) I want to see for each car how many kilometres will be driven with one litre of petrol in the given periode from 2002/04/01 till 2002/05/06 ? Can somebody help me with the correct formula(s)? If necessary I can give some additional information.
Gr. Jeroen.
In a table for a certain car I've got following fields:
Date Qty. petrol(ltr) Amount (H)Odomtr
2002/04/01 52,2 53,24 15500
2002/04/11 47,4 46,45 16069
2002/04/15 53,4 54,20 16843
2002/04/23 29,3 30,47 17136
2002/05/02 48,4 49,61 17867
2002/05/06 49,6 51,09 18497
In our company we've almost fifty cars. In one Crystal Report ( if possible the CrossTab) I want to see for each car how many kilometres will be driven with one litre of petrol in the given periode from 2002/04/01 till 2002/05/06 ? Can somebody help me with the correct formula(s)? If necessary I can give some additional information.
Gr. Jeroen.