Report Calculations

Question

Report Calculations

seajoker

Say Hey Kid

Points: 700
More actions
June 20, 2008 at 1:41 pm

#189468

I have a report that shows weekly inventory levels. I would like to show the difference between weeks both the number inventory and percent changed. Can you create this type of expression in the table or is it necessary to create a dataset with the calculations?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Margaret Norkett SSC Veteran Points: 223 More actions · Answer 1

No you don't have to have another dataset.

right click on your list of fields over on the left hand side where it says report datasets, and click the add. You'll have a space for a calculated field. Just name it, put in your formula and then put it in your report.

Thanks and have a NICE day!,

Margaret

seajoker Say Hey Kid Points: 700 More actions · Answer 2

My data looks like this:

Date Qty

2008-05-12 00:00:00650540

2008-05-19 00:00:00627207

2008-05-26 00:00:00551382

2008-06-02 00:00:00580634

2008-06-09 00:00:00581563

2008-06-16 00:00:00508013

I want to compare week over week. I cannot get the correct calculation using a calculated field.

seajoker

nigel.c.west Hall of Fame Points: 3468 More actions · Answer 3

Why not try using an expression that utilises the PREVIOUS function.

For example:

= Fields!TotalAmount.Value - PREVIOUS(Fields!TotalAmount.Value)

You might wish to take a little care about when PREVIOUS points to nothing, i.e. it is on the first record.

Using this method, you don't need a calculated field or a change to the dataset, just put the expression in the report table.

Nigel West
UK