SSRS Report convert expression value from amount to %

(0) Share

Report

Posted on by D365FO DEV

406

Hi, im trying to convert the value of a field to be shown in my ssrs report in %, anyone can provide me the full expression.

THANKS

I have the same question (0)

All responses (24)

Answers (1)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi Mounir, I didn't tested it but you can try ssrs expression specified in this article

stevethompsonmvp.wordpress.com/.../

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

Hi, i checked but the pictures are not opening, maybe if u can help, my expresion in the report design in coming like this: =Fields!Ex_LineDiscAmount.Value

i need to change this expression to convert to %. is that possible u provide me with the correct exp using my scenario?

thanks

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi Mounir,

Refer to the below link and see if it helps.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c90223e1-96a6-475b-891a-8046bda596dc/ssrs-format-with-percent-sign?forum=sqlreportingservices

Thanks,

Girish S.

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Try the below code in the field expression in report and change Format property to P for that field.

= FORMAT(Fields!Ex_LineDiscAmount.Value, "F2") & "%"

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

hi, i tried this method: .

but when i print report im getting 380000.00% while decimal value is 3800.

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

As per article, if you use F2, it will show 3800 instead of 38000. You can also try adding 2 in Decimal places instead of 0.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Try setting decimal place as 2 in the same property window.

Thanks,

Girish S.

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

a sales order has a unit price value of 20 000 with 1 quantity in the sales order line. we did a line discount amount for 2000 which means 10% if you we need to convert it to percentage. then, we did another line discount but this time the line discount percent for 10%. this line discount percent will be deducted from the value resulted by the deduction of the line discount amount from the unit price. after we did the line discount amount for the unit price 20 000, the item has value now of 18 000. then, we do the line discount percent of 10%, the amount value is now 16 200. if we convert it all to amount, the value deducted from the sales item is 3800 which equals to 19%. so the line discount amount is converted to 10% and the line discount percent of 10% is actually 9%, so a total of line discount percent after conversion is 19%

Was this reply helpful? Yes No
Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Right, in that case, you need to divide LineDisc (3800) with Unit Price and multiply with 100 to get the percentage. (3800/20000) * 100 = 19%.

You can apply same formula in LineDisc Textbox in report.

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report

yes i did it, but the value is coming 1900% not 19% while decimal place is 0

here is my exp: =((Fields!Ex_LineDiscAmount.Value/(Fields!Qty.Value*Fields!SalesPrice.Value)))*100

Was this reply helpful? Yes No