Profile Picture

Rounding Percentages and Numbers, adding a second row in legend so it displays two lines per box

Posted By Steve Murray 2 Years Ago

Rounding Percentages and Numbers, adding a second row in legend so it...

Author
Message
Steve Murray
Posted 2 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 11 Months Ago
Posts: 17, Visits: 79
Below is a sample of my chart.  I would like to round the number values (with a comma) and no decimals.  On the percentage, I would like zero decimals.  See chart below.

https://www.nevron.com/forum/uploads/images/c39c36c1-e943-491a-9397-eae4.png


Nevron Support Team
Posted 2 Years Ago
View Quick Profile
Supreme Being

Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)

Group: Moderators
Last Active: 2 days ago @ 8:33 AM
Posts: 2,593, Visits: 2,279
Hello Steve,
You can achieve your requirement like this:
1. In the Data Labels tab, Format filed, leave only: <label>
2. In the General tab, Data -> Label field, use an expression like:
=FIRST(Fields!LABEL.Value) + " - " + SUM(Fields!VALUE.Value) + " - " + FORMAT((SUM(Fields!VALUE.Value)/SUM(Parent.Fields!VALUE.Value)), "P0", "en-us")

Hopefully this helps.

Best Regards,
Nevron Support Team



Steve Murray
Posted 2 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: Forum Members
Last Active: 11 Months Ago
Posts: 17, Visits: 79
Formatting of the number worked! No decimals now, but I still do not display "," (comma) separator for the thousands. Below is my format:  =FORMAT(SUM(Fields!Total_Current_Charges),"N0")



Nevron Support Team
Posted 2 Years Ago
View Quick Profile
Supreme Being

Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)

Group: Moderators
Last Active: 2 days ago @ 8:33 AM
Posts: 2,593, Visits: 2,279
Steve, your expression for the format looks ok. However, this may be related to the culture which is used.
If culture is not specified in your expression, the default current culture is used.

You can take a look at the help documentation:
Pivot Engine > Functions > Text Functions
Resources > Numeric Format Strings
Resources > Culture Table

You can update your expression like this:
=FORMAT(SUM(Fields!Total_Current_Charges), “N0”, “en-US”)

or if you prefer to use custom numeric formatting:
=FORMAT(SUM(Fields!Total_Current_Charges), “##,#”, “en-US”)


Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic