So I need to change the precision on just one custom property value.
Let's say the CP "Length" is entered with 4 decimal places 8.0000
I do some math in the equation manager and want to output a value with 4 decimal places, say 16.0000, but SW outputs just 16
How can I get the value to output correctly?
I know ROUND() can get you less decimals when you have too many.
Is there a way to make this work the other way?
I guess I need trailing zeros in equations? Is there an option for that?
Ok, apparently I was slightly wrong.....I DON'T have an ER for this.....I THOUGHT I had created an ER, but now I don't see it.
So, I just created one!
1-15178984636
Ran into same problem trying to populate by bill of material using a custom property that is populated from an equation. I voted for this ER. Please others log into customer portal and do the same if you find this page.
Yes, equation and link to Global Variable cut off zeros, but the table cell still can be linked to dimension with zeros unlimited:
the result:
That's cool, but in my case I need it to be driven in a BOM.
I need to drive a description in my custom properties, so it can show up correctly in the BOM on any drawing.
hmm... maybe i can combine this idea with equations...
Sarah Dwight wrote:
That's cool, but in my case I need it to be driven in a BOM.
I need to drive a description in my custom properties, so it can show up correctly in the BOM on any drawing.
hmm... maybe i can combine this idea with equations...
This is exactly where I ran into it.
Unfortunately, I couldn't get the Global variable that was linked to a custom property to show trailing zero's in the custom properties. This was because it used the global variable as text, which meant that it used exactly what the global variable was evaluated to. When you try to change the custom property to a number, you get an error and this is because the linking text to link it to a global variable is text and not a number. Was really frustrating.
Maybe you can get it.
What I found out is that you can link things to BOM's and use the {3} right before your BOM equation and it will show trailing zero's.
I ran into it specifically when I was doing this last challenge (an other places, but here is where I already have a small explanation of it:
The 10th Weekly Power-User Challenge (September 15th, 2017): Measuring Wine Carafe
Well I figured out my problem, at least for now.
I was using Global Variables to link to the dims in my sketch/features, so I could select them in the Custom Properties.
I wan't doing any math, just linking the value.
Now I realize I don't need to do that?! You can just link straight to the dim with "DIM@Sketch1" in the CP... ugh.
And it comes out exactly as I need it!
Why did I think that linking like this did not work?
Dan Pihlaja This reminds me of something I came across on the forum a while ago.... idk where.
If you did all the math in the equations, then linked a dim in a dummy sketch to the GV, then linked straight to the dim in your CP... wouldn't that give you your value with the proper trailing zeros or decimal places??
Sarah Dwight wrote:
Dan Pihlaja This reminds me of something I came across on the forum a while ago.... idk where.
If you did all the math in the equations, then linked a dim in a dummy sketch to the GV, then linked straight to the dim in your CP... wouldn't that give you your value with the proper trailing zeros or decimal places??
I know that I tried that with the carafe thing, but it blew up on me. Something to do with the update order. I couldn't get it to work.
Ah I haven't read that thread yet. Maybe if I have time later...
I especially like your custom property named ARGH:
Castle of Aaargh (Monty Python and the Holy Grail) - lucidenglish74
Hahaha, man I really need to re-watch that! Haven't seen Monty Python and the Holy Grail in years. I don't know if it will get better with age, but I sure hope so.
Just came across this written by Alin Vargatu, maybe give these a try:
http://www.javelin-tech.com/blog/2011/06/fine-tune-your-equations/
Thanks Dan, I have seen this before and it does not work for trailing zeros. The one suggestion I think would work is Format() from #2, but that does not seem to be a legal function or I just can't get it to work.
I tried it as well, and I couldn't get it to work either. Thought maybe you would have more luck.
Is this ER still active?
SW 2018 and still cannot control trailing zero's in equations.
Can we upvote an ER or do we have to start one ourselves.
The FORMAT command does not appear to be a valid command:
You can use the Format command from VBA in the equation body. For 2 digits precision the equation would be:
”Mass_in_lb”=Format( “SW-Mass”/2.2,”#.##”)
Don Hill wrote:
Is this ER still active?
SW 2018 and still cannot control trailing zero's in equations.
Can we upvote an ER or do we have to start one ourselves.
The FORMAT command does not appear to be a valid command:
You can use the Format command from VBA in the equation body. For 2 digits precision the equation would be:
”Mass_in_lb”=Format( “SW-Mass”/2.2,”#.##”)
Format doesn't work (even if you can get the equation manager to accept it) because the equation manager expects a numeric value. A formatted number is a string, not a numeric value. When an equation outputs a string, VBA will automatically convert that string (if valid) to a numeric value, so the evaluated value will not retain the trailing zeroes.
Trailing zeroes in equations are impossible to get. It is a current limitation.
No matter what precision you have, no matter what rounding you use, trailing zeroes are impossible in the equations area (global variables, etc...)
Every where else they work.....not there.
I have an ER for this....I will post it as soon as I find it