Create a Percentage formula in Revit

[brianwclayton1969]

Good afternoon Revit people,

Is there any way to create a "Percentage formula" calculation in Revit for the schedules?

I was looking in the Schedules under "Formatting" and Calculate totals, nothing made sense.

Is there something simple I'm just missing.

Thanks

[barthbradley]

I don't understand what you want to do? Can you provide an example? 

[Yien_Chao]

Hi

There is No need to create a new category for this. Just filter them by any distinctive type parameter would be enough.

[ToanDN]

Yes.  Create a Calculated value parameter and choose Percentage instead of Formula.

[brianwclayton1969]

I appreciate the assistance this is ALOT closer than I was. I have attached a screen shot of the steps. When I plug in the formula it calculates it but the answer is off. Did I do something incorrect plugging in my formulas or parameter?

Thanks

[ToanDN]

[brianwclayton1969]

I understand that part, I switched it before to "percentage", but every time it calculates everything to 100%, I need a way for it to divide "ladies" into "total capacity". I know I'm all around it I cannot pin point it. I'm missing something simple.

See attached please on what I did and my outcome.

[ToanDN]

---

@brianwclayton1969 wrote:

I understand that part, I switched it before to "percentage", but every time it calculates everything to 100%, I need a way for it to divide "ladies" into "total capacity". I know I'm all around it I cannot pin point it. I'm missing something simple.

See attached please on what I did and my outcome.

---

Why don't you share you file here?

[TripleM-Dev.net]

Hi @brianwclayton1969,

So I'm guessing you need the % Ladies Shoes of the total, then switch the fields in the formula:

Ladies / Total = %, and set the format units to percentages.

- Michel

Ps, the Percentage option in a calculation field is to calculate percentages between rows (of totals) not between between columns.

[Mike.FORM]

Doing it this way since your calculated parameter is a number you can then go to the formatting tab, select percentage from the list and then select the field format button, you can then change the units, rounding and the unit symbol if you want.

@TripleM-Dev.net you beat me too it.

[brianwclayton1969]

I'm getting the answer close to what I want, I just cant get the decimal to move in the correct direction. I'm following the instructions you all are giving and I'm grateful, what small step am I missing? I removed all the unnecessary columns.

See attached.

[ToanDN]

That result is wrong no matter you move the decimal places.  No way 6510 / 13576 = 57.71%.   Share you file here.

Here is an example:

[TripleM-Dev.net]

@brianwclayton1969,

How many elements are in the Schedule, if it's more than 1 then this won't work!

Then you need a Percentage field and not a calculated and the "Total Capacity" should have totals enabled.

- Michel