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.

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.

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.

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!

- 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.
- 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.- 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!!- 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!

regardsHi, 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?

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.

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!