Sitemap

Amicuk Programming Answers

Round 3 Digits before decimal in Chart and Table

-0001-11-30   Views:1

Advertisement

Hi Guys, Do you know where I can find the option/property in the chart and table to round 3 digits before decimal. Refer snapshot below: For example, in below case Y axis original value is 40,000, 80,000 etc. but it should show on the graph and table

Hi Guys,
Do you know where I can find the option/property in the chart and table to round 3 digits before decimal. Refer snapshot below:
For example, in below case Y axis original value is 40,000, 80,000 etc. but it should show on the graph and table without '000' 
Thanks.
Warm Regards Badal Ratra

The replay answer
Advertisement
Hi Badal,
After testing the issue in my local environment, we can refer to the following steps to achieve your requirement:
Right-click the vertical axis (or textbox in table) to open the Vertical Axis Properties (or Text Box Properties) dialog box.
Click Number in the left pane, then select Number under Category group.
Set “0” as Decimal places, select “Use 1000 separator (,)” and select “Show values in” with “Thousands”.
The following screenshot is for your reference:
If there are any other questions, please feel free to ask.
Thanks,
Katherine Xiong
Katherine Xiong
TechNet Community Support

Go to See the other 2 answers

Round 3 Digits before decimal in Chart and Table

Category:DefaultRelease time:-0001-11-30Views:130

Hi Guys, Do you know where I can find the option/property in the chart and table to round 3 digits before decimal. Refer snapshot below: For example, in below case Y axis original value is 40,000, 80,000 etc. but it should show on the graph and table[More]

Round float to 2 decimal place in the table

Category:DefaultRelease time:2015-10-11Views:130

Hi, One field in a table in my DB has float datatype. I insert some data into this table. The value read from a textbox I input as 0.02 for example. after insertion, I select the table and the field of the table shows the number as 0.0199999995529652[More]

How to count the number of digits before decimal value

Category:DefaultRelease time:-0001-11-30Views:130

Hi I've a decimal value like this 123,456.700000000000 I need output as 6 (because I've 6 digits before decimal)Try Declare @d decimal(30,9)=123456.700000000000 SELECT FLOOR(@d) SELECT len(FLOOR(@d)) Thanks Manish Please click Mark as Answer if my po[More]

Price per unit is getting round off to two decimal places.

Category:DefaultRelease time:-0001-11-30Views:130

Hi Gurus, In the Billing output, the Price per unit is getting round off to two decimal places. How can we avoid this or allow 4 decimal places for such cases. In the same pricing procedure, we have two pricing condition types PR02 and ZR01. When PR0[More]

How do I round calculations to two decimal places (form-wide)

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I've created an order form where customers input the quantity of product they want to order and the form outputs the total due (including shipping and sales tax). Depending on user input, the resulting total sometimes contains more than two decim[More]

Round off to two decimal places

Category:DefaultRelease time:-0001-11-30Views:130

hi i have a filed in it values are there i want to round off to two decimal places which is the function module for it please suggest regards AroraHi Nishant Arora, Please check this code. DATA: N1 TYPE P DECIMALS 4 VALUE '0.0565',            N2 TYPE[More]

How to get only two digits after decimal point of an expression

Category:DefaultRelease time:-0001-11-30Views:130

i am doing simple multiplication between two float numbers. both the numbers have two digits after decimal point. so naturally the result will have 4 digits after decimal point. i want to get only two digits after decimal point. help me please...If y[More]

Chart and table in WAD.

Category:DefaultRelease time:-0001-11-30Views:130

HI all, I want display web items  chart and table one below the other in web templet , but when I try to drop then one below the other in empty web templet , they are palce side by side automatically. how we can display then chat and table blow each[More]

Rounding off to nearest decimal point

Category:DefaultRelease time:-0001-11-30Views:130

i have these values 35.2 35.3 35.4 35.5 35.7 35.8 35.9 36.0 i am looking for indexes closet 35.74 in my array. (which is index 4.) i used the "round to nearest" function and it gave me 36. which is index 7. what other ways to get the right index[More]

Purchase price to have 4 digits after decimal point

Category:DefaultRelease time:2015-10-11Views:130

Hi Friends, Would you please help me out with this issue? The purchase price needs to have 4 digits after the decimal point, because the product/component would be packed and sold in other unit, which may give huge value difference. The price can be[More]

Rounding Rule upto 3 Decimal Places in Tax Condition(SABRIX)

Category:DefaultRelease time:-0001-11-30Views:130

Hi, We are Using SABRIX for Tax determination and need to round up Condition Type XR1- XR6 to round upto 3 Decimal Places. Do we need to To Change ALT Calc Type- 301306or Alt Cond Base Value -- 16  or have to change Currency  decimal Places in transa[More]

Hot
Hello, We are querying a OLAP (SSAS 2008) cube using Excel 2007 by creating a data connection to SSAS server with an extended parameter “Custom Data”. We are using custom data parameter to apply our application’s user security to filter dimension mem [More]
How do I view multiple photos, side by side, so I can make a comparison and decide which ones I want to delete?  I used to be able to select them all with the shift or command keys and then bring them into the Edit screen.  Now only the first one com [More]
Are there anyways to packaged a J2ME app with the emulator? So that when people click on a bat file, that emulator will run along with the J2Me app? I saw this in the jbuilder console C:\WTK21\bin\emulator.exe -classpath "C:\MyApp\classes;" -Xde [More]
I have a declarative component. In it it has a table. One of the columns is a selectOneCheckbox. It is mapped, in a jsff binding page, to a BC VO. It is giving this error. :( Error: pt1:pt_region1:2:pt1:CDDC:dist_dc_pc1:CDtable:1:j_id__ctru19pc28: 'f [More]
I am recording with an HV20 and I would like to keep the pulldown when I export the movie. Is there any way to do that?Ghosting? I don't know what you mean by that. The frame interpolation of going from 29.97 to 23.976 is very complex. Applications l [More]
How do I accept the new iTunes agreement after upgrading to iso7?All Apple servers are undergoing a huge number of hits.  I think tomorrow or even the next day, all upgrade and activation servers will be in better shape. I know this is a pain . . . H [More]
Hello, By mistake I created one data file in the local file system instead of ASM diskgroup. Initially I created the data file with 100MB, autoextensible to 100M,maxsize 2G, but then I stopped autoexntensible, so that less data file size would be bet [More]
I use a two-monitor setup, and when I'm away from my desk, I like to use spaces and organize my windows that way. I have my most-used applications set up in the spaces pref pane so they open in their own spaces. it works great. but when I then return [More]
Hello everyone, I  recently installed Windows 8 (64 bit) on my HP Pavillion DV6-6170SD and most of the drivers were working right away. I used to have Beats by Dre audio software before I updated my Windows and now I can't find it on the website belo [More]
I've searched everywhere for an answer but can't find anything.  When I try to export an audio file from Premiere to Soundbooth, Premiere hangs. The only change to my system recently was I downloaded some Matrox codecs.  Anyone have any ideas or solu [More]