Hello Group,
I am new still to formulas and need some assistance. I am trying to figure out how I can get two parameters to schedule out to calculate correctly in my schedule. I have two shared Parameters that I am trying to schedule, I have all my single boxes scheduling correctly but cannot get my double devices to add both parameters. I am not sure if I need to be using a "greater than" formula or a "if(and" formula. I have tried this so far, but its only calculates the one side"if(or(Box 1 UMA, Box 2 UMA), 1, 0)". With this I only get my "Box 1" to schedule I want both Box 1 and Box 2 to schedule as indvidual numbers and calculate both values together to give me a total.
Not without giving up company policy. All I need is for all my Box 1's to calculate and all my Box 2's to calculate to give me one total. Some families will have both "Box 1 and Box 2" shared parameters nested in the family. I just can't get it the family with two parameters to give me 2. I am only getting to calculate 1 for both parameters.
well then, I'm lost.
You say you have a formula written that is not working correctly -- if(or(Box 1 UMA, Box 2 UMA), 1, 0). What parameter type is "UMA".? On/Off? And what kind of value is 1 or 0. A number? So, if either box is checked return 1 ; if neither box is checked return 0. Yes? No?
FWIW: the default for an On/Off parameter is NULL. It has no value whatsoever until it's activated by checking and unchecking the box. Maybe that info helps.
If you already have Box a and Box 2 placed in the family why don;t you make them shared families and schedule the actual count?
And below is doing it with formulas:
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.