Q: Case Statement /w Crosstab Sum?

[Mike]

Hi. I'm using a simple crosstab to generate totals and percentages, which I have already completed successfully
My data rows are as follows:

[=Fields.NameOfField]
Totals (Of each column)
Percentages (Of each column)
Savings (Of Each Column) <--- (This is what I want to calculate)

MAIN QUESTION ---> For the row labelled 'Savings', it is not just a count of what is in each column. I'd like to calculate my 'Savings' in a new row, based on what the Name of my Field is (Pseudo-ish code below), preferably in an EXPRESSION in the Telerik Report DESIGNER:

Savings = SUM( IF (Fields.NameOfField = 'Name1'), THEN (Savings = (1000-200) * Fields.Column1)
IF (Fields.NameOfField = 'Name2'), THEN (Savings = (750-150) * Fields.Column1) IF (Fields.NameOfField = 'Name3'), THEN (Savings = (500-100) * Fields.Column1) )

...But I am unsure how to generate a total this way. Please advise : )

[Hinata]

Hi Mike,

I'm not aware of your exact report structure, but you will probably need to nest the conditional statements in an expression like the following:

= Sum(IIf(Fields.NameOfField = 'Name1', (1000-200)*Fields.Column1,
       IIf(Fields.NameOfField = 'Name2', (750-150)*Fields.Column1,
          IIf(Fields.NameOfField = 'Name3', (500-100)*Fields.Column1, 0)
          )
       )
    )

You can learn expressions and how to use them in great detail here: Telerik Reporting Expressions.