I would like to get percentage for a given field value. I am achieving this in excel by using formula. Is there a way to write down formula in SSRS?
I attached images here.
I need this
In excel i achieved by using formula, how to get this one in SSRS?
I used this custom code to get the percentage sum
and i used this expression in tablix
source here
Yes, It's possible.
Use below expression
Here, ReportItems!Number.Value is the textbox name of Name Texbox and ReportItems!Number1.Value is the textbox name of Total Textbox.
See the below Image, It's working fine.
To Get Sum of percentage.
I would suggest to follow below things,
Go to Report properties, then Go To Code and then create the following function.
Now, beside Name - Create Placeholder and set font to white as we don't required to show calculation on this cell. Do like below image.
Now, Set Expression like below image and text like this,
Hope, It will be helpful to you. Thanks