calculated sum

calculated sum

• voko

  No ideas Seems to be a pretty basic function.
  

• alan lan

  Beautiful!! Works great. Thank you for your help.
  

• LabibaSeif

  Not sure if this solution will work for you, but you can add a Calculated Field to the Data Set, say: "FilteredQty", defined as (assuming Quantity is an integer):
  
  CInt(iif(Fields!Country.Value = "USA", Fields!Quantity.Value, 0))
  
  Then in your report you can use this expression:
  
  Sum(Fields!FilteredQty.Value), wich should return 4 rather than 10
  
  To make it dynamic, "USA" can be replaced by a report parameter.

  
  
  

• Allison

  Do you want the report user to interactively select a dimension value, and have the sum adjusted accordingly In that case, you could set up a filter on the dataset, where the expression is the dimension column value, the operator is "=" and the value to compare against is the input parameter value.
  
  

• R.S

  Nope. I just want to do a sum based on a dimension. Something like this.
  
  Dataset1
  
  Country   Quantity
  USA            1
  USA            3
  CANADA       1
  MEXICO        3
  CANADA        2
  
  The sysntax I would use in Business Objects would be:
  
  SUM(QUANTITY) WHERE(COUNTRY = "USA") 
  
  this expression would return 4.
  
• calculated sum