Skip to Content
0
Former Member
Jun 03, 2009 at 10:40 AM

Crystal Formula

58 Views

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