Equation function "INT" doesn't seem to work

[charlesculp]

Am I missing something? I am trying to add an extra sheet at the end of all drawings. Because it is not part of the drawing itself, I need the page count for the drawing to be less than the actual calculated page count. I tried to use an equation in the custom properties to make this happen.

To do this, it does some math, but it looks like it turns it into a floating point number, and uses the length unit standard tolerance for significant digits (three past the .). Ok, so I used the "int" function, but it does nothing. What gives?

Shouldn't

Code: Select all

int ( $PRP:"SW-Total Sheets" - 1 )

return an integer? Solidworks 2022 SP5.0

[jcapriotti]

Hey Charles, long time.

I don't see a way to make this work with the equations in custom properties. The INT function is working somewhat if you put a decimal value in like 5.523, it changes it to 5.000. Excel does the same thing if you have decimal place formatting set on the cell.

image.png (6.18 KiB) Viewed 326 times

[JSculley]

Yeah, the INT function is borked. You wouldn't be bothering with this at all if this SPR were addressed:

SPR769752 - Ability to set certain drawing sheets to be ignored from total sheet count

[charlesculp]

Yeah, the INT function is borked. You wouldn't be bothering with this at all if this SPR were addressed:

SPR769752 - Ability to set certain drawing sheets to be ignored from total sheet count

Nice, I will +1 that SPR.

Nice to hear from you, Jason. Back doing engineering work again after a decade as a manager.

[josh]

I hope that's an old pic you're using there for your profile... I've considered you somewhat of a colleauge for almost as many years as you look old in that pic.

[gupta9665]

You may have to use a macro that counts the total sheet, subtract 1 and update the custom property. Downside, run macro every time you add/remove a sheet. A macro or add-in to run in the background and act on file save might help updating the sheet count.

[charlesculp]

I hope that's an old pic you're using there for your profile... I've considered you somewhat of a colleauge for almost as many years as you look old in that pic.

That was at least four haircuts ago. I had to get it trimmed when I started going on job interviews. It's all still there, though. The picture is from 2021, I believe.

My solution was to do this Solidworks PDM Dispatch Action (during check-out) by creating two variables, one that is the $PRP:"Total Sheets" and the other is the new calculated value. It determines if there is the attached change sheet at the end, and then if there is it subtracts a page from the total. This afternoon I will make it work for a variable number of change sheets; in case the designer gets ambitious and makes multiple pages worth of changes at a time.

[AlexLachance]

Yeah, the INT function is borked. You wouldn't be bothering with this at all if this SPR were addressed:

SPR769752 - Ability to set certain drawing sheets to be ignored from total sheet count

So um, I'm trying to vote on this SPR, but can't seem to find where anymore. I used to do it through the Knowledge base but it doesn't seem to work anymore, I get the search result, but can't vote on it. I tried looking up on the Platform but didn't find any topic on the platform linked to it either...

https://support.3ds.com/knowledge-base/ ... :SPR769752

Edit: Is it the badge on the right of the title to "Add to Favorites" that counts as a vote? If so, that is truely intuitive, feels just as intuitive as the platform.