View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff C Jeff C is offline
external usenet poster
 
Posts: 35
Default 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