AnsweredAssumed Answered

Want to add QTY column with "Total QTY"

Question asked by 1-F44GHU on Jun 10, 2009
Latest reply on Nov 15, 2010 by 1-F44GHU

Like • Show 0 Likes0
Comment • 12

Trying to take the default "QTY." and add it to my own custom "Total QTY". Right now I created another column labeled "Total Job QTY".

The equation is: 'QTY.'*"$PRPSHEET:"QTY Total"".

It comes out as: ='QTY.'*"3"...so somehow the equation is screwed up. If I just make the equation 'QTY' then the correct QTY per 1 show up.

No one else has this question

Outcomes

12 Replies

Filipe Venceslau Jun 10, 2009 12:42 PM
Mark Correct
Correct Answer
Hi Nick!
I'm trying to do the exact same thing, and have run across the exact same problem, over and over. Tried so many work arounds and still can't get it to work. I think there might be some glitch here and we might have to wait for a fix or something, it doesn't seem to want to calculate anything with values coming from sheet/model/view properties for some reason.
I've contacted solidworks support, and they're working on this for me.
The only solution I've come across so far, was to add that same custom property for every part in the bom and calculate between custom prop in parts, but that is not flexible/dynamic, for that, you'd be better off just editing your formula in your BOM for every time your master quantity changed.
A quick easy fix, would probably be to just make a little macro that links that formula "QTY" * "MASTER.QTY" to your custom property. In other words, a macro that would just read your custom property get the number and actually write the formula in the BOM for you, so there would be no links there.

I have a post open with this query too, so keep an eye open. I might actually make this macro today, and I'm good with sharing.

Greetings!
Like • Show 0 Likes0
Actions
- 1-F44GHU @ Filipe Venceslau on Jun 10, 2009 12:45 PM
  Mark Correct
  Correct Answer
  
  Filipe Venceslau wrote:
  
  Hi Nick!
  
  I'm trying to do the exact same thing, and have run across the exact same problem, over and over. Tried so many work arounds and still can't get it to work. I think there might be some glitch here and we might have to wait for a fix or something, it doesn't seem to want to calculate anything with values coming from sheet/model/view properties for some reason.
  
  I've contacted solidworks support, and they're working on this for me.
  
  The only solution I've come across so far, was to add that same custom property for every part in the bom and calculate between custom prop in parts, but that is not flexible/dynamic, for that, you'd be better off just editing your formula in your BOM for every time your master quantity changed.
  
  A quick easy fix, would probably be to just make a little macro that links that formula "QTY" * "MASTER.QTY" to your custom property. In other words, a macro that would just read your custom property get the number and actually write the formula in the BOM for you, so there would be no links there.
  
  I have a post open with this query too, so keep an eye open. I might actually make this macro today, and I'm good with sharing.
  
  Greetings!
  
  Thanks and I have never made a macro so any help would be apreciated.
  Like • Show 0 Likes0
  Actions
  - Jeff Hamilton @ 1-F44GHU on Jun 10, 2009 2:07 PM
    Mark Correct
    Correct Answer
    Try taking the period (.) out of QTY.
    Like • Show 0 Likes0
    Actions
    - 1-F44GHU @ Jeff Hamilton on Jun 23, 2009 11:44 AM
      Mark Correct
      Correct Answer
      that doesnt work either....It seems so easy yet its so hard to figure out.
      Like • Show 0 Likes0
      Actions
      - 1-F44GHU @ 1-F44GHU on Jun 23, 2009 2:14 PM
        Mark Correct
        Correct Answer
        I have one Column labeled "Q1" this is the standard "QTY" column but just renamed it to "Q1". Then I have a column labeled "QTY". The plan is to have this column take the quantity from "Q1" and multiply it to a custom property that I set-up for "total job qty" and give me a TOTAL count of parts per job.
        Like • Show 0 Likes0
        Actions
        Filipe Venceslau @ 1-F44GHU on Jun 23, 2009 2:30 PM
        Mark Correct
        Correct Answer
        I've contacted Solidworks support on this, and no one seems to have a solution.
        There is a way of linking to the custom property of the main model in a view ($PRPMODEL:"CUSTOM_PROP_QUANT"), the problem is that the equation editor seems to be quite buggy still, and we might have to wait for a fix maybe in the next SP.
        
        Good luck.
        Like • Show 0 Likes0
        Actions
        1-F44GHU @ Filipe Venceslau on Jun 23, 2009 3:07 PM
        Mark Correct
        Correct Answer
        There is something quirky. I even did an equation:
        
        Q1 (which is my normal qty) * 5 (just a plain number) and it all changed the total qty from 1 to 5 which is a part (qty of 1) * #5. But somehow it gets weird when you try to link a property. I even changes the property "type" from Text to Number. To me this seems like an easy equation. Why it is screwing up is beyond me. Its little things like this that drives me nuts!!
        Like • Show 0 Likes0
        Actions
        Filipe Venceslau @ 1-F44GHU on Jun 23, 2009 3:19 PM
        Mark Correct
        Correct Answer
        Trust me...I know how you feel, I spent hours and hours over this! I gave up, It just won't carry the property over properly, I tried various other solutions, even involving equations, and none seem to do the trick.
        There is some bug in the equation editor. I've requested Solidworks to have a look into it, and they are supposed to get back to me. So i'll let you know what i figure out.
        and you do the same!
        I would love to get this feature working!
        
        regards
        Like • Show 0 Likes0
        Actions
        qinghai jin @ Filipe Venceslau on Aug 3, 2010 1:33 PM
        Mark Correct
        Correct Answer
        Hi, Buddy,
        
        It is feasible to use equation editor in Solidworks and reference sketch to do the total quantity calculation.
        use one line in refer. sketch with its display dimension , which will be driven by the formula in equation editor.
        then link the displayed dimension valued with the total quantity or the parameter with the same value in equation editor into custom properties.
        
        Magic Logic, right?
        Like • Show 0 Likes0
        Actions
        Scott McFadden @ qinghai jin on Aug 3, 2010 1:40 PM
        Mark Correct
        Correct Answer
        Thank you,
        This is good stuff to remember.
        Like • Show 0 Likes0
        Actions
        qinghai jin @ Scott McFadden on Aug 5, 2010 1:46 PM
        Mark Correct
        Correct Answer
        My pleasure, Scott,
        
        In fact, the Equation editor just like the tool of logic and/or math work , the lines in reference sketch just like interchanging/switching 'database', custom properties just like data terminal client acccess. in fact, use an attached construction line to work as an interchanging/switching 'database' is better.
        Like • Show 0 Likes0
        Actions
        1-F44GHU @ qinghai jin on Nov 15, 2010 10:43 AM
        Mark Correct
        Correct Answer
        Hi Jin:
        
        I appreciate your help. This looks very interseting, however I dont understand the concept of putting a reference sketch line. Would this sketch be placed in the TOP LEVEL Assembly model? I think I understand the idea, just need some more clarification.
        
        Thanks in advance for help.
        
        NH
        Like • Show 0 Likes0
        Actions

Want to add QTY column with "Total QTY"

Outcomes

Related Content

Recommended Content