Post reply

Need to apply a Sum for the Below

  • July 22, 2013 at 5:17 am

    #395177

    I have an expression as below..

    =IIF(Fields!TypeDesc.Value = "ABC",ReportItems!Textbox98.Value,IIF(Fields!TypeDesc.Value = "CCC",(((ReportItems!Textbox98.Value-(ReportItems!Textbox86.Value-ReportItems!Textbox83.Value))*ReportItems!Textbox72.Value)/1000000),""))

    For the TypeDesc = "ABC"

    Summation is working fine, but for TypeDesc = "CCC" , summation is not working in the next TextBox.

    Any help...

  • July 22, 2013 at 7:27 am

    #1634464

    I don't see any SUM in your expression. But I have not had much luck doing conditional sum in SSRS and I usually add columns to the dataset that have the condition applied, then sum the individual columns.

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

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