May 7, 2012 at 8:47 am
Good Morning Guys,
I would like to ask how can i work around or solve this error that i have in the summation of numeric totals in SSRS. the field that was used is of type money in SQL and i was doing the Sum(function) in the expressions and it gives me a warning/error displayed below. could you please help me on this?
Much Thanks
Noel
May 7, 2012 at 9:45 am
Stylez (5/7/2012)
Good Morning Guys,I would like to ask how can i work around or solve this error that i have in the summation of numeric totals in SSRS. the field that was used is of type money in SQL and i was doing the Sum(function) in the expressions and it gives me a warning/error displayed below. could you please help me on this?
Much Thanks
Noel
What is the expression being used for the Canadian dollars? Is this a formatted value such as
=format(amount, "currency") & "(CAD)"
This would now be a text value rather than a money, as amount was.
Fitz
May 7, 2012 at 10:25 am
Hi Mark,
Thanks For the Clue You Gave Me The Format("") thingy. it did the trick.
Much Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply