help with Average function

  • Thread starter Thread starter Liz Taylor
  • Start date Start date
L

Liz Taylor

Hello,

I have a query that returns a Year to Date value. I wish to calculate a
monthly to date average from this YTD value. For instance, let's say my
fiscal year starts in October and my sales YTD is $10,000 then my MTD AVG
should be 10,000/3 = 3.333.

I know I could just type [YTD]/3 and get the value I'm looking for, but I'm
wondering if there is a function that could check what month it is and what
number that corresponds to, and then calculate the average.

Is this possible?

Thanks,

Liz
 
Thanks,

It works great!

:-)



Chris said:
try ...

10,000 / (iif(month(date())<10,month(date()) + 3,month(date
()) - 9))

-----Original Message-----
Hello,

I have a query that returns a Year to Date value. I wish to calculate a
monthly to date average from this YTD value. For instance, let's say my
fiscal year starts in October and my sales YTD is $10,000 then my MTD AVG
should be 10,000/3 = 3.333.

I know I could just type [YTD]/3 and get the value I'm looking for, but I'm
wondering if there is a function that could check what month it is and what
number that corresponds to, and then calculate the average.

Is this possible?

Thanks,

Liz


.
Click to expand...
Click to expand...
 
Back
Top