Pivot Tables, Calculated Fields, and variable denominator

[Jeff C]

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]

Try this:

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