Column value returned #ERROR in Matrix Report !!!!!

Question

HI Guys,

I am trying to put this expression in a column of a matrix,but when I preview the report the column value I get is #ERROR .DId anyone get the same error message like this.Here is the expression,

=Format(Fields!Aman.value/100,"P")

Is there any mistake in the expression??

ANy help will be greatly appreciated.

Thanks.....

Answer 1

Hi,

I don't know of any "P" format.

What is it supposed to do?

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

Answer 2

=Format(Fields!Aman.value/100,"P")

The expression looks OK to me. Are you sure that the field Aman has all numeric values? Can you try the below expressions?

=Format(CDec(Fields!Aman.value)/100,"P")

=Format(CInt(Fields!Aman.value)/100,"P")

---

Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

Answer 3

Actually it is a percentage value,even I dont kno what the P stands for this is a report which I have to add two additional columns,but when I add th columns I get the error.

Answer 4

Hello,
The Format(value, “P”) function returns a value multiplied by 100 and display as a percentage. And the precision is two decimal places by default.
Based on your description, it seems that the value of the field “Aman” percentage value. If you want to format the percentage, you can try to set the formatting options in textbox properties dialog box: right-click the textbox which display the percentage values, and select the “TextBox properties”. Just the following screen shot shows, you can format the decimal places of the percentage value.

Regards,
Fanny Liu

 

---

Fanny Liu
TechNet Community Support

Answer 5

Hi,

you can try this expression

=Format(VAL(Fields!Aman.value)/100,"P")

Take a look into this link for some additional info regarding this issue

---

Aftab Ansari