
Re: Set a Variable with an Input Formula to Round Up
Vladimir Urazhdin Dec 7, 2015 3:33 PM (in response to Dave LeCount)
Re: Set a Variable with an Input Formula to Round Up
Dave LeCount Dec 7, 2015 4:14 PM (in response to Vladimir Urazhdin)But that's only in the properties of a SolidWorks file, correct? What I have is the BTUs at 60Hz value entered into a field on my Data Card, and then I want to run it through a formula to come up with a second variable to populate the BTUs at 50Hz field. Nothing is coming from or going to a SW part or assembly.

Re: Set a Variable with an Input Formula to Round Up
Vladimir Urazhdin Dec 7, 2015 4:21 PM (in response to Dave LeCount)You can use function "round" in equations only.

Re: Set a Variable with an Input Formula to Round Up
Dave LeCount Dec 8, 2015 8:02 AM (in response to Vladimir Urazhdin)That's what I was afraid of.

Re: Set a Variable with an Input Formula to Round Up
Charley Saint Dec 7, 2015 7:14 PM (in response to Vladimir Urazhdin)If you truly want to "round up" use this as your input formula (it adds 1, finds the decimal point and returns everything left of it):
$LEFT($Add($Mul(%Chillers_Pump_Pressure_60Hz_1st%,.644),1),$Find($Add($Mul(%Chillers_Pump_Pressure_60Hz_1st%,.644),1),.))

Re: Set a Variable with an Input Formula to Round Up
Dave LeCount Dec 8, 2015 10:56 AM (in response to Charley Saint)Thank you! That did it!
For the most part I understand what is going on with your formula except how everything to the right of the "." is being stripped off. Is it as simple as "Left" is subtracting everything from the "Find" portion of the formula from the "Add" portion of the formula?
Thanks again!

Re: Set a Variable with an Input Formula to Round Up
Charley Saint Dec 8, 2015 11:49 AM (in response to Dave LeCount)Yup, so if the number was 12.34 then the find portion returns 2 since it's in position 2 in the string (1 is in position 0 and 2 is in position 1) so the left 2 characters of the number make 12 and voila.




