aged report based on two date fields

[frankee_gee]

Help with AGED report

We rent boards and each rental is uniquely tagged w/ a number. We ERECT & DISMANTLE boards daily.

I've been asked to submit an aging report that shows Tags separated by Four (4) AGED categories.

1. 1-30
2. 31-60
3. 61-90
4. 91-Plus

We Have two dates we are working with
TagLog (table)

1.TagNo
2.ErectDate
3.DismantleDate



An example of a calculation to figure the number of Erect Days would be:

=ErectDate-DismantleDate if DismantleDate is null , Today()

How can I create this formula in PowerPivot?


2. How can I tell PowerPivot to then separate into 4 categories?

Thanks for our time,

Frank.