Thursday, February 9, 2012

#error

Can someone tell me why this expression generates a #ERROR when I view the
report? Here is my expression:
=FormatCurrency(iif(Fields!FinancialCodes.Value = 1,
SUM(Fields!FinancialAmount.Value),"Div_Group1"),0)
--
Thanks!I ran into a simliar issue. If you look at your output window you will see
warning messagse as to why its showing up. More than likely its something
like string was in the incorrect format, meaning the parser couldn't do
something with it.
Check to see if Finanicalamount.Value is a number before hand with an iif
statement.
"Candy" <Candy@.discussions.microsoft.com> wrote in message
news:A89F6883-422E-469A-B1F3-93A9A57ED6B6@.microsoft.com...
> Can someone tell me why this expression generates a #ERROR when I view the
> report? Here is my expression:
> =FormatCurrency(iif(Fields!FinancialCodes.Value = 1,
> SUM(Fields!FinancialAmount.Value),"Div_Group1"),0)
> --
> Thanks!

No comments:

Post a Comment