Pivot Tables, Calculated Fields, and variable denominator
 

I need to create a calculated field dividing the sum of one field by the
number of days in the month prior to the date in one of the data fields.

Mon PT

2/4/2008 26

I have tried =Sum(pt)/EOMonth(Mon,-1) and =Sum(pt)int(EOMonth(Mon,-1)) with
no results.

Is there a solution out there?

Thanks in advance
--
Jeff C
Live Well .. Be Happy In All You Do

Pivot Tables, Calculated Fields, and variable denominator
 

Try this:

=PT/DAY(DATE(YEAR(Mon),MONTH(Mon),1)-1)

Jeff C wrote:
I need to create a calculated field dividing the sum of one field by the
number of days in the month prior to the date in one of the data fields.

Mon PT

2/4/2008 26

I have tried =Sum(pt)/EOMonth(Mon,-1) and =Sum(pt)int(EOMonth(Mon,-1)) with
no results.

Is there a solution out there?

Thanks in advance


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com