Jump to content

Rounding Schedule - Windoor


Recommended Posts

Trying to get a schedule to show the width of my glazing just for pricing purposes, so I want to round things off to the nearest 10mm. Currently, the schedule (set as a database) is pulling from the windoor objects and I have set 'user2' to the 'overall width'. I can add 'ROUND' or 'INT' but that just makes the numbers all appear as 50mm which is not even in the same ball park - do the functions not work with numbers pulled from objects.

 

=('WinDoor 6.0'.'__User2')

=ROUND('WinDoor 6.0'.'__User2')

 

Thanks.

Link to comment

Try this:  =ROUND(VALUE('WinDoor 6.0'.'_User2')/10)*10

 

Here's what's going on.  The data in the field _User2 is actually text, not numeric.  So first you have to use the function VALUE to return a real number.  Then you can round it.

 

The trick to rounding to the nearest X is to first divide by X, then round it, then multiply by X again.

 

hth

Link to comment

Can you make a file with just a couple windows and the worksheet you're working on and post it?

 

We don't get WinDoor over here so there may be something about it that I'm unfamiliar with.

 

But it works on regular VW windows.

 

I probably have the name of the record or field incorrect.

Link to comment

@michaelkI manage to get it to work. User 2 is one of the custom fields that you can specify to create custom things like door height or width x height. Since I was just after a standard one I changed the schedule to be 'Overall Width' and with your rounding formula, the numbers went to the nearest 10. Thanks for the help.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...