I need to calculate a value in pounds where a fine has to be paid if a problem has occured in the last 12 month rolling period.
The formula is 1.2 (x-1)
1.2. is a fixed value
x is the number ot times the problem has occured in the last 12 months (rolling 12 month period) on a particular location
1 is a fixed value
Therefore the more times the problem has occured at a location, the higher the fine
I have 2 problems;
1) I am unable to write the above formula onto a crystal report as I cannot find a function that will allow 'to the power' of a number.
2) I am unable to establish the value of X (the number ot times the problem has occured in the last 12 months (rolling 12 month period) on a particular location). My field names are probdefn.probcode (the problem), probdttm (the date it occured), comparea.unitdesc (the location). I have tried to calculate this using a subreport but I don't seem to be getting the values I am looking for, and I seem to have all of the subreport data showing in my main report instead of just the X value.
Any assistance would be gratefully received