Need Help figure out this formula in my Finish Schedule.

[KMillerVGJK4]

I have Finish Schedule and some of my cost for my finishes are by the slabs and others are by square feet. I'm trying to have a field that will do the following:

If the (number of slabs are < 1) then the field shall take the (material area * material cost) , but if the (number of slabs are > 0) then the field shall (number of slabs * material cost)

This is what I have: IF(NO. SLABS > 1 (Material: Area / 1 SF * Material: Cost),(NO. SLABS*Material: Cost))

New to using formulas, if anyone can help me figure this out I would appreciate it.

thanks,

[Redrunner92 · Accepted solution]

---

@KMillerVGJK4 wrote:

This is what I have: IF(NO. SLABS > 1, (Material: Area / 1 SF * Material: Cost),(NO. SLABS*Material: Cost))

---

First, I immediately noticed your formula is missing a comma. See it in red font in the quotation above.

Second, you used greater than when your explanation leads me to believe you want to use less than in your main conditional statement. This is because the first option after the conditional statement is for the "if true" result, while the second is for the "if false" result.

Third, is your "No. Slabs" parameter a number or an integer? If it is an integer, then the value range <1 will only yield 0 (when dealing with absolute values, that is to say, when excluding negative numbers). A number type parameter would be better suited to allow for decimal ranges between zero and one.

Just some thoughts. Will the formula work when you consider these three points?

[KMillerVGJK4]

@Redrunner92  Thanks, adding the comma has it working now. Now my problem is, I have my schedule combining like Instance ( unchecked Itemize every instance). So now its multiplying all the instance instead of just taking the number of slabs the column is reporting. So example the field read "1" but since there is 6 itemize its multiplying it 6 times.

I just want it to multiply it by the number with in the filed.

See attached image

[barthbradley]

---

@KMillerVGJK4 wrote:

So now its multiplying all the instance instead of just taking the number of slabs the column is reporting. So example the field read "1" but since there is 6 itemize its multiplying it 6 times.

---

It ain't going to happen.  Go have a beer.  Been on the Wish List forever.  Learn to love it -- and drink to it.   

[Redrunner92]

Try adding the Count field to your schedule. You can make it a Hidden field if you don't want to show it. Then make the final part of your formula read like so:
... , (NO. SLABS*Material: Cost/Count))
Let's see if that works.

[KMillerVGJK4]

@Redrunner92  No that's not working, it wont let me use Count in the formula. It gives me this message:

[Redrunner92]

I was afraid of that. I haven't tried to use the Count field in a formula for quite a while and this reminded me why. In that case, that specific calculation won't be possible with Revit's current capabilities, unfortunately 😞

[KMillerVGJK4]

Thanks!! you still were a BIG help.

[Redrunner92]

You're welcome!