Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Using schedule calculated total in a formula

12 REPLIES 12
SOLVED
Reply
Message 1 of 13
Keith_Wilkinson
9247 Views, 12 Replies

Using schedule calculated total in a formula

Is it possible to use a schedule calculated total in another formula?  



"Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime."
Maimonides
12 REPLIES 12
Message 2 of 13
L.Maas
in reply to: Keith_Wilkinson

No, the formulas are row based.

The only possible solution would be to add a parameter to the families. In this parameter you would have to enter the calculated total manually (or automatically through the API). When automating you would risk to create circular references.

Louis

EESignature

Please mention Revit version, especially when uploading Revit files.

Message 3 of 13
Keith_Wilkinson
in reply to: L.Maas

I thought that might be the case.  Pity.

 

Might try doing something with Dynamo instead... ;o)



"Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime."
Maimonides
Message 4 of 13
L.Maas
in reply to: Keith_Wilkinson

Dynamo should be a possibility. I understood it should be possible to pull totals from a schedule.

Louis

EESignature

Please mention Revit version, especially when uploading Revit files.

Message 5 of 13
Keith_Wilkinson
in reply to: L.Maas

My thinking was that I could actually produce the total in dynamo.

 

Mind you I'm saying that with no real idea of what I'm doing or how I'm going to do it.  But I like the idea of at least trying something in Dynamo!  🙂

 



"Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime."
Maimonides
Message 6 of 13
nrubens
in reply to: Keith_Wilkinson

Not to revise an old thread... but, you can extract the calculated total as a percentage and place it in a calculated field on the same row.  To do this; set the field you want the total from to show "calculated totals" under formatting.  Then create a new field to extract the percentage of the total of the field you need the total value from; Make sure you go back to the formatting tab and change the field formatting from percentage to general.  Once that is set up, just create a new field to calculate the total by simply diving the first field by the percentage, it should then give you the total in the field for the row. 

 

Capture2.PNGCapture.PNG

Message 7 of 13
ToanDN
in reply to: nrubens

Brilliant!!

 

I tested it and it works without even changing the Percentage format to General.

 

Capture2.PNG

Message 8 of 13
carmine.rago
in reply to: nrubens

I know this is an old post, but sometimes gets actual 😛

 

Is it possible to push these "calculated values" in a family tag? I manage to create schedule, I can't find the way to push them in the tag....

 

Thanks!

Message 9 of 13
PReed2P6QL
in reply to: carmine.rago

Only if the original parameter you were getting the calculated total from is a shared parameter. 

Message 10 of 13
nidhimathur.ar
in reply to: nrubens

Thanks so much for this.. I've been going nuts trying to play with the formula to extract avergae unit area per level! 
I found the other posts quite confusing - yours was the simplest to follow! 

Cheers,

Nidhi

Message 11 of 13
marko.Zeljkovic
in reply to: nrubens

absolutely brilliant. thank you so much.
Hint for posting formulas, rename the parameters to 2 - characters long so its easier to follow. Cheers
Message 12 of 13
RDAOU
in reply to: Keith_Wilkinson

.

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Message 13 of 13
Keith_Wilkinson
in reply to: RDAOU

it's the forum - on any post that I've started, if someone replies, it automatically likes it for me and sets it as the solution - despite multiple requests Autodesk hasn't managed to fix it.  Can't say I'm surprised... 



"Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime."
Maimonides

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Rail Community


Autodesk Design & Make Report