July 18, 2012 at 3:53 pm
=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
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
I get a result in the detail line. In the group footer I get #Error.
July 21, 2012 at 3:13 pm
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