pie chart series expression

Question

hi

i am using this expression in my series properties 

=Fields!Name.Value & 100 * Sum(Fields!MV.Value) / Sum(Fields!mv.Value, "DATASET1")

when i preview it gives me error like "Value was either too large or small for decimal"

Any idea?

Answer 1

Hi There

Thanks for your posting. What are you trying to achieve here. What would be your desired out put. Can you please put some sample data and let me know

Many thanks

Syed Qazafi Anjum

Answer 2

Hi Tsql,

According to your expression, it seems that you want to display the percent value that the corresponding "MV" value of each "Name" accounts for the total value of "MV". In this case, you can achieve it refer to the steps below:

1. Right-click your chart, and select “Show Data Labels”.
2. Right-click the data labels, select “Series Label Properties”.
3. Click the expression button and type in the expression below:
=fields!Nmae.Value & FormatPercent(sum(fields!MV.Value)/Sum(Fields!mv.Value, "DataSet1"),2)

The reports looks like below:


If you have any questions, please feel free to ask.

Regards,
Charlie Liao