topic Re: Using schedule calculated total in a formula in Revit Architecture Forum

Using schedule calculated total in a formula

Keith_Wilkinson — Thu, 15 Jan 2015 21:08:47 GMT

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

Re: Using schedule calculated total in a formula

L.Maas — Fri, 16 Jan 2015 08:00:29 GMT

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.

Re: Using schedule calculated total in a formula

Keith_Wilkinson — Fri, 16 Jan 2015 08:44:34 GMT

I thought that might be the case. Pity.

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

Re: Using schedule calculated total in a formula

L.Maas — Fri, 16 Jan 2015 12:20:16 GMT

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

Re: Using schedule calculated total in a formula

Keith_Wilkinson — Fri, 16 Jan 2015 12:28:39 GMT

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! 🙂

Re: Using schedule calculated total in a formula

Anonymous — Wed, 26 Oct 2016 17:01:49 GMT

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.

Re: Using schedule calculated total in a formula

ToanDN — Wed, 26 Oct 2016 19:46:45 GMT

Brilliant!!

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

Re: Using schedule calculated total in a formula

Anonymous — Thu, 30 Aug 2018 10:23:10 GMT

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!

Re: Using schedule calculated total in a formula

Anonymous — Fri, 14 Dec 2018 17:14:32 GMT

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

Re: Using schedule calculated total in a formula

Anonymous — Wed, 12 Jun 2019 15:41:33 GMT

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

Re: Using schedule calculated total in a formula

marko.Zeljkovic — Mon, 20 Dec 2021 15:13:16 GMT

absolutely brilliant. thank you so much.
Hint for posting formulas, rename the parameters to 2 - characters long so its easier to follow. Cheers

Re: Using schedule calculated total in a formula

RDAOU — Mon, 20 Dec 2021 15:25:09 GMT

Re: Using schedule calculated total in a formula

Keith_Wilkinson — Mon, 20 Dec 2021 15:38:40 GMT

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...

Re: Using schedule calculated total in a formula

artM23CU — Sat, 27 Jul 2024 14:46:18 GMT

Or Autodesk could actually create a not so convoluted way of doing things that it takes forums and 300 hours to create automated schedules based on data already available. This has been a massively annoying exercise which could have been avoided with some simple tools in revit. We pay 3500per year per station and the changes from version to version are inconsequential. There's still no built in way of renumbering items sequentially, and it's been what 20 years now? By the time autodesk fixes this AI will negate the need for revit altogether.