Expressions, expressions! Subtracting fields from different datasets

• DataAnalyst110

  Ten Centuries

  Points: 1361

  More actions

  May 7, 2012 at 4:47 pm

  #392200

  The other expression I've been working at today is subtracting two fields from different datasets. Both of these fields are COUNT'd on in SQL before the dataset is populated. In other words, the syntax to populate the dataset is COUNT(Person_ID). Either way, I've been trying this:

  =Fields!Count.Value, "KCOM_CurrentCycle" - Fields!Count.Value, "KCOM_CurrentCycle"

  ...but I get the following error:

  The Value expression for the textrun 'Textbox8.Paragraphs[0].TextRuns[0]' contains an error: [BC30205] End of statement expected.

  I should mention that when I use the expression builder to add the fields, they come in like this:

  =Sum(Fields!Count.Value, "KCOM_CurrentCycle") - Sum(Fields!Count.Value, "KCOM_CurrentCycle")

  However, it only repeats one value for each of the rows.

  Does anyone have thoughts on what I may be missing? I'm just breaking into the wild world of data analysis, so thanks for your patience!

• gsc_dba

  SSCertifiable

  Points: 5407

  More actions

  May 10, 2012 at 2:19 am

  #1485534

  The sum of all values - (minus) the sum of all other values will be the same, that is why the values are repeating.

  =Fields!Count.Value, "KCOM_CurrentCycle" - Fields!Count.Value, "KCOM_CurrentCycle"

  Did you intend to subtract the same count from the same datasource?

  gsc_dba