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.
Solved! Go to Solution.
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:
This now shows whatever the value in the attribute actually is.
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.
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.
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?
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.
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?
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.