Post reply

Report Calculations

  • 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?

  • June 20, 2008 at 1:59 pm

    #832063

    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

  • June 20, 2008 at 3:29 pm

    #832098

    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

  • June 23, 2008 at 4:33 am

    #832546

    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