Delta Calculations

[Bonediggler1]

Hello -

I have a matrix report which sums accounts receivable by month/year as column and bucket(1-30 days, over 90 days etc) as rows.

What I need to do is create monthly, quarterly and yearly delta calculations at the end of the report, i.e. as columns to the right of the most recent month/year.

I am not getting very far with this as I cannot even create a calculated field that identifies the maximum month/year value (aggregate functions cannot be used in calculated field expressions).

Not sure why the "MAX" function is even available when creating calculated fields as you cannot use it in a calculated field!

Obviously I am missing something.

Thank for the help!!

 

[xlbo]

create your MAX items in the SQL -i.e. return current year / month as fields in the data set and retun to SSRS - you can then reference them to your hearts content

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question