IF formula in schedules not being recognized

[Xeryg]

I'm working on creating a Plumbing Calculation Schedule in Archicad and am having difficulties with one formula. For a Business calculation, it's supposed to be '1 per 25 for the first 50, then 1 per 50 for the remainder'. In the property Manager, I have a formula to calculate the either the Male or Female occupancy using an IF formula. The problem I am running into is that when when I input the information into the formula (If (Logical, value if true, value if false)), I'll still get an answer, but unfortunately I dont think it is recognizing the false part of the formula.

For example, I have a Business Occupancy load of 117 people, which would be about 58 male/females. The IF formula would calculate it and would spit out 2.76 for the required water closets, which is wrong and it needs to be 2.17...
This is the formula that I have that is calculating this: PLUMBING OCCUPANCY TYPE = 'BUSINESS', IF (FEMALE RATIO , 50, FEMALE RATIO / 25, ( ( FEMALE RATIO - 50) / 50) +2).

the red text is not being recognized, and if I even edited that portion, there would be no changes to the output.

Would any one have an idea of what maybe going on and how to fix it?

[Laszlo Nagy]

Maybe the expression is wrong. I think it should not say 'BUSINESS' after the = sign. Shouldn't the 'BUSINESS' part be within the IF() function?

Also, after IF(, it says FEMALE RATIO and a comma character, so it does not compare FEMALE RATIO to anything. 

Anyway, could you show a screenshot of this formula as you see it in the Property Manager?

So we could see the Property, its Data Type, Availability and the full expression?

It would be great to see this for all relevant Properties like PLUMBING OCCUPANCY TYPE and FEMALE RATIO.

[Ricardo Lopez]

Hi @Xeryg 

It would be great if you could explain what you need or the excerpt from the regulations you want to parameterize in more detail, so that we can understand it better and try to help you.
Anyway, if you need to learn more about Archicad's expressions and properties, I recommend the following links:

• Expression-Defined Properties - Workflow Guide (e-book)
• Occupancy Design Validation with Expressions