Post reply

Can =SUM be used to add 2 different TextBox values together

  • June 4, 2008 at 3:29 pm

    #183052

    I have textboxes with Aggregate functions in them and I have another textbox that I would like to add the values of those functions together:

    Example:

    Textbox B(SafetyStockQuantity) value =MIN(Fields!Safety_Stock_Quantity.Value)

    Textbox D(WorkingInventory) value =sum((Fields!Forecast_Quantity.Value)/ 8)

    Textbox E(OnHandTarget) I need the value of Textboxes B+D.

    These are also in a Group Header, so I don't know if that is my problem either.

    I tried:

    =sum(ReportItems!SafetyStockQuantity.Value + ReportItems!WorkingInventory.Value)

    I get this error:

    The value expression for "OnHandTarget) uses an aggregate function. Aggregate functions can only be used on report items contained in report headers and footers.

    I need to have this information formated across in the group level, is there another way of doing this?

    Any thoughts would be great.

    Thanks

    Shannon

  • June 4, 2008 at 7:49 pm

    #824619

    Leave out the sum() so that the formula is:

    =ReportItems!SafetyStockQuantity.Value + ReportItems!WorkingInventory.Value

    You are already doing the aggregations in each of those fields, and don't need to sum them up again.

  • June 5, 2008 at 9:17 am

    #824878

    Thank you. I over looked the obvious.

    Shannon

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

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