Improper use of boolean expressions

[msosaMVWKG]

Hello!

I get the Improper use of boolean expressions message, i dont know how to make it work.

IF (Number = 26, Area / 2, Area)

where Number is the room number. I want specific rooms to be divided by 2 for their final area.

Thanks!

[rxi.gg]

What type of parameter 'Number' is?

[msosaMVWKG]

Its the room number (in the room tag), does that make it a text or integer?

[rxi.gg]

That type of parameter doesn't work in calculated value.

you have to create a Number-type parameter and it works

[msosaMVWKG]

The formula works! however, i dont get that other window with the categories where you choose "Habitaciones". I get an empty column on my schedule

[msosaMVWKG]

Nevermind its working now! I had to edit the idd in the room tag that i wanted. Thank you so much!!

[rxi.gg]

You have to edit the parameter in every room 🙂

[rxi.gg · Accepted solution]

great! 

Please accept it as a solution if it has solved your doubt!

[msosaMVWKG]

Quick question, how do i write the statement if there are more numbers i want to choose? for example, I want that the formula divides the area by 2 for specific items on the list with idd 26, 28, 30 and 32.

[ToanDN · Accepted solution]

---

@msosaMVWKG wrote:

Quick question, how do i write the statement if there are more numbers i want to choose? for example, I want that the formula divides the area by 2 for specific items on the list with idd 26, 28, 30 and 32.

---

If you do it that way your formula will get very long and prone to errors.

Just add a yes/no parameter to the schedule, name it Half Area, tick it for any rows need to be divided by 2, untick for the rest, then use the formula:

if (Half Area, Area/2, Area)

[rxi.gg · Accepted solution]

Do it with a yes/no parameter