Post reply

IIF statement in Calculated field doesn't sum in Group footer = #error

  • July 18, 2012 at 3:53 pm

    #276072

    =iif(Fields!Posting_Date.Value>="10/01/2011" AND Fields!Posting_Date.Value <="10/31/2011" AND Fields!Source_Code.Value="ACTJNL",Fields!Amount.Value,0.00)

    I can't sum this calculated field in a group. Does this have to do with nesting aggregates? Is there a solution in SSRS2008? I can get around this issue by creating the formula in the datasource. However, I'd like to know how others have solved similar issues.

    Thanks,

    David

  • July 19, 2012 at 7:22 am

    #1514831

    do you get result for

    =iif(Fields!Posting_Date.Value>="10/01/2011",Fields!Amount.Value,0.00)

  • July 19, 2012 at 9:44 am

    #1514954

    I get a result in the detail line. In the group footer I get #Error.

  • July 21, 2012 at 3:13 pm

    #1515890

    You need to go for a custom code that sets a flag and value in a variables, and set the value based on the condition(flag value) in the page footer.

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

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