Friday, November 23, 2012 8:14 PM
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,
Is there any mistake in the expression??
ANy help will be greatly appreciated.
Friday, November 23, 2012 8:19 PM
I don't know of any "P" format.
What is it supposed to do?
Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu
Friday, November 23, 2012 8:49 PM
The expression looks OK to me. Are you sure that the field Aman has all numeric values? Can you try the below expressions?
Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com
- Proposed As Answer by Hasham NiazEditor Friday, November 23, 2012 9:15 PM
Friday, November 23, 2012 11:40 PMActually 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.
Monday, November 26, 2012 3:38 AMModerator
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.
TechNet Community Support
Monday, November 26, 2012 7:25 AM
you can try this expression
Take a look into this link for some additional info regarding this issue