Diggerdidoo
New Member
- Joined
- Oct 14, 2002
- Messages
- 5
Please can you help, I had a Access program written for me at work which I am now trying to use:-
The problem seems to be the following formula:-
Forecast_Accuracy: Avg(IIf([AvgPeriodUsg]>=[Forecast],1-(Abs([Forecast]-[AvgPeriodUsg])/[AvgPeriodUsg]),1-(Abs([Forecast]-[AvgPeriodUsg])/[Forecast])))
If AvgPeriodUsg = zero this seems to throw up a problem, can I get round this within the formula.
Cheers DD
The problem seems to be the following formula:-
Forecast_Accuracy: Avg(IIf([AvgPeriodUsg]>=[Forecast],1-(Abs([Forecast]-[AvgPeriodUsg])/[AvgPeriodUsg]),1-(Abs([Forecast]-[AvgPeriodUsg])/[Forecast])))
If AvgPeriodUsg = zero this seems to throw up a problem, can I get round this within the formula.
Cheers DD