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