Skip to main content
S
STEVEG21-Topaz I
21-Topaz I
September 14, 2018
Solved

Number of places for reporting

  • September 14, 2018
  • 3 replies
  • 7443 views

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.

Best answer by STEVEG

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.

3 replies

S
STEVEG21-Topaz IAuthor
21-Topaz I
September 14, 2018

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

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
September 17, 2018

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
S
STEVEG21-Topaz IAuthor
21-Topaz I
September 17, 2018

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.

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
September 17, 2018

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
S
STEVEG21-Topaz IAuthorAnswer
21-Topaz I
September 17, 2018

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.

    MarcoTosin
    MarcoTosin21-Topaz I
    21-Topaz I
    September 17, 2018

    It is something convoluted in the same way to get the very latest revision.

    Marco
    S
    STEVEG21-Topaz IAuthor
    21-Topaz I
    September 17, 2018

    But it is much easier.

     

    I don't think I would have found it without your suggestion of the DATEDIFF function.  I started thinking there has to be some other function that does this so I tested several others and came across the To Number.

     

    So thank you Marco!

      Terms & ConditionsAccessibility statement