June 20, 2008 at 1:41 pm
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?
June 20, 2008 at 1:59 pm
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.
June 20, 2008 at 3:29 pm
My data looks like this:
Date Qty
2008-05-12 00:00:00 650540
2008-05-19 00:00:00 627207
2008-05-26 00:00:00 551382
2008-06-02 00:00:00 580634
2008-06-09 00:00:00 581563
2008-06-16 00:00:00 508013
I want to compare week over week. I cannot get the correct calculation using a calculated field.
seajoker
June 23, 2008 at 4:33 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply