Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Create a Percentage formula in Revit

12 ANTWORTEN 12
Antworten
Nachricht 1 von 13
brianwclayton1969
1196 Aufrufe, 12 Antworten

Create a Percentage formula in Revit

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

 

 

12 ANTWORTEN 12
Nachricht 2 von 13
barthbradley
als Antwort auf: brianwclayton1969

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

Nachricht 3 von 13
Yien_Chao
als Antwort auf: brianwclayton1969

Hi

 

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

Nachricht 4 von 13
ToanDN
als Antwort auf: brianwclayton1969

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

Nachricht 5 von 13
brianwclayton1969
als Antwort auf: ToanDN

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

Nachricht 6 von 13
ToanDN
als Antwort auf: brianwclayton1969

ToanDN_0-1681775471220.png

 

Nachricht 7 von 13
brianwclayton1969
als Antwort auf: ToanDN

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.

Nachricht 8 von 13
ToanDN
als Antwort auf: brianwclayton1969


@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?

 

Nachricht 9 von 13

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.

 

Screenshot 2023-04-19 193517.png

 

- Michel

 

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

Nachricht 10 von 13
Mike.FORM
als Antwort auf: brianwclayton1969

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.

Nachricht 11 von 13
brianwclayton1969
als Antwort auf: Mike.FORM

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.

Nachricht 12 von 13
ToanDN
als Antwort auf: brianwclayton1969

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:

 

ToanDN_0-1681931925231.png

 

Nachricht 13 von 13

@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

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report