help with a zero calculation

[wcrc]

I am heading in the right direction, but I need help getting over the hump.

I have a calculation that returns the average turn around time (in days) on jobs. I need to take into account that some jobs are less than one day in duration, and therefore are 0 days long.

Can I use something like:

If [jobdays] <1 then [jobdays] =1

I'm still learning so forgive me if the syntax doesn't work right, but I'm sure someone can help me figure a way to deal with the 0 returns, I just have not been able to get it just right.


Thanks in advance

 

[Pat Hartman]

You can nest an expression within the Sum() function.

Sum(IIf(Jobdays < 1,1,Jobdays))

 

[wcrc]

I was just reading about that too!

I had just started reading about the sum function as I got your reply notice.

Thanks alot