Wesley Burrows Posted February 14, 2018 Share Posted February 14, 2018 I'm almost certain this is a stupid question but for the life of me I can't figure out why when sorting ascending negative values (X on a motor X,Y sheet). Why I get this: Logic would dictate that -45 is less than -15. it seems like it should sort as, -45, -15, 15, 45. What am I missing? (This was generated with Spotlight > Reports > Create Hoist Worksheet. Quote Link to comment
JBenghiat Posted February 14, 2018 Share Posted February 14, 2018 This is an issue in 2018 — Vectorworks isn't always recognizing data as numeric if the cell began as a text field. You can see that the text is left justified, which is incorrect for numeric values. You can try reformatting the row and recalculating. Quote Link to comment
Recommended Posts
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.