Hi All,
I want to perform a simple operation of Dividing two Numbers and display the
result as percentage.
For the result textbox, the format is N and the expression used is
"=Fields!Col1.Value / Fields!Col2.Value" but i get #Error.
Am i missing something ? what should be the correct expression / Format '
Thanks in Advance
KunjalSee if this makes a difference:
"=Iif(Fields!Col2.Value=0,0,(Fields!Col1.Value / Fields!Col2.Value))"
And in the SQL to get Col1 and Col2, make sure that both Col1 and Col2
are numeric.
SELECT
isnull(Col1,0) as Col1,
isnull(Col2,0) as Col2
FROM Table [...]
MoMad
No comments:
Post a Comment