Nevron Forum
Back
Login
Register
Login
Register
Home
»
Nevron Vision for SharePoint
»
Nevron Chart for SharePoint
»
Rounding Percentages and Numbers, adding a second row in legend so it...
Rounding Percentages and Numbers, adding a second row in legend so it displays two lines per box
Post Reply
Rounding Percentages and Numbers, adding a second row in legend so it...
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
Goto Topics Forum
Author
Message
Nevron Support
Nevron Support
posted 10 Years Ago
ANSWER
Post Details
Group: Administrators
Posts: 3.1K,
Visits: 4.2K
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
Reply
Like
0
Steve Murray
Steve Murray
posted 10 Years Ago
ANSWER
Post Details
Group: Forum Members
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")
Reply
Like
0
Nevron Support
Nevron Support
posted 10 Years Ago
ANSWER
Post Details
Group: Administrators
Posts: 3.1K,
Visits: 4.2K
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
Reply
Like
0
Steve Murray
Steve Murray
posted 10 Years Ago
ANSWER
Topic Details
Group: Forum Members
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.
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Post Reply
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search