Pivot Tables, Calculated Fields, and variable denominator

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top