cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Number of places for reporting

SOLVED
Level 13

Number of places for reporting

I didn't see anything on the resource for reporting page.

 

I have a few attributes in PDMLink with the type Real Number.  I want them in a report but the results truncate the values.  If the value is 0.092 the report shows a zero (0).  If the value is 3.55 the report shows 3.  Is there any way to specify to show a certain amount of digits?  I am using CAD Document.  Not EPM Document or WTPart.

 

The funny part of this is I saved the report and created a New Data Monitor to export to .csv.  That actually shows the correct values using scientific notation.  At least it's correct.  But I want the correct values in the report as well.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Number of places for reporting

I figured out how to set it to show the actual values.

 

On the Select tab add the function "To Number".

Select somewhere else on the tree to get it to display correctly.

Then select the To Number and then Add button again.  It will give a sub-entry:

ToNumber.JPG

 

This now shows whatever the value in the attribute actually is.

14 REPLIES 14

Re: Number of places for reporting

By the way...I am still in 10.1 and going to 11.0 next month.

Re: Number of places for reporting

Hi Steve,

the behavior you described is quite strange because is exactly the opposite as I would expect.

 

Normally decimal value are limitless unless you use function TRUNCATE to reduce the number.

 

Can you try to add to your report a value using DATEDIFF (difference between two dates) and see the result?

 

I would expect a value with lots of decimals.

 

Marco

Re: Number of places for reporting

Marco,

 

Thank you for that but I am not sure how to put that in and what to use.  I assume it goes on the Criteria tab but I don't know how to specifically implement that in my situation.

 

When I added a Condition and changed the Type to Function there is no DATEDIFF.

Re: Number of places for reporting

In the Select tab you can use Subtract function and then select two dates (for example Creation date and Last Modified).

 

See attached image (sorry for italian language but my browser is localized).

 

How many decimals do you see?

 

 

Marco

Re: Number of places for reporting

That shows up to 10 digits after the decimal.

Re: Number of places for reporting

I just came across one attribute on a model that the actual value is 4.99.  The report shows 4

Re: Number of places for reporting

Perfect.

This is the default behavior.

 

So the issue regards your report if you see less digits than that in example, because there isn't a preference to drive number of digits.

 

If you want to have less digits you have to use Truncate function.

Marco

Re: Number of places for reporting

And that is OK for the Subtract function which I did for the last creation date vs. the last modified date.  But I need more digits for the value of the attribute.  How would I use that to ADD digits to one value?

Re: Number of places for reporting

The test I asked you, was to be sure the report was run with default conditions.
At the moment I haven't got any idea why it doesn't not run in the same way for CAD attributes.

Marco