Cancel
Showing results for
Did you mean:

# SUMIF function within the expressions list

Experimenter

hi all,

is it possible to use the SUMIF function within the expressions list in nx? i basically want the same function that excel has.

i have an assembly of various rooms (each a separate part) and each room has an air supply per hour value. However, not all rooms are supplied by the same air conditioning unit. Therefore, i want to use the SUMIF function to sum all the air supplied by each AC unit.

i hope this was clear.

kind regards, kris.

7 REPLIES

# Re: SUMIF function within the expressions list

Siemens Phenom

KJFuller --

I highly suspect we can figure this out.  :-)

How are these AC units and the assignments of rooms to AC units defined currently?

For a given room (part) how would I know which AC unit supplies it?

Taylor Anderson
NX Product Manager, Knowledge Reuse and NX Design
Tel: +1 (602) 441-0683
taylor.anderson@siemens.com

# Re: SUMIF function within the expressions list

Experimenter
Hi taylor,

So the AC UNIT has been added as an attribute to each part and so has a body measurement for the volume of the room, along with the amount of air changes per hour. Then as an expression i calculated the required air supply per hour as = volume of room * air changes per hour = AIR SUPPLY, and then also added this as an attribute.

So each part has attributes as:
AC UNT (0-5)
AIR CHANGES (0,5,8,10,20,25)
VOLUME (mm^3)
AIR SUPPLY (=volume * air changes)

What i would like is a sumif for each ac unit 0-5.

Thank you very much.

Sent from my iPhone

# Re: SUMIF function within the expressions list

Siemens Phenom

Can you help me understand "required air supply per hour"?

This looks like a list of values?  Is AIR_SUPPLY also a list of values, then?

There's not a List type attribute today...  (List expressions exist, of course.)  How again are you storing these?

Taylor Anderson
NX Product Manager, Knowledge Reuse and NX Design
Tel: +1 (602) 441-0683
taylor.anderson@siemens.com

# Re: SUMIF function within the expressions list

Experimenter

hi taylor,

the air changes per hour has been added as a list in the expressions list.

AIR_SUPPLY is then a calculation in the expression list. it is a result of the volume of a room multiplied by one of the options from the air changes per hour list.

AIR_SUPPLY is then used as an attribute for each part.

does this clear things up?

# Re: SUMIF function within the expressions list

Siemens Phenom

That makes sense.  So one more question... :-)

How do you indicate which of the air changes is contributing to the AIR_SUPPLY?  I presume you're pulling one value from the list with an nth() statement or something like that?  What do you calll that "index", out of curiosity?

Taylor Anderson
NX Product Manager, Knowledge Reuse and NX Design
Tel: +1 (602) 441-0683
taylor.anderson@siemens.com

# Re: SUMIF function within the expressions list

Experimenter
Yeah so that just relates to a pre-determined value from our company standards. Depending on the use for each room, one of the air change values is selected from the list.

I hadnt used the nth() formula. I simply chose one of the values that was provided in the drop down list created.

Sent from my iPhone

# Re: SUMIF function within the expressions list

Experimenter

do you need any further info?

did you manage to think of a way to solve this issue?

thanks, kris.