Why can't Revit add simple schedule totals together?

[hashah935ZJ]

Hi Guys,

Sorry if this has already been posted, but I'm trying to figure scheduling out. 
I have two columns of totals. Both the totals are calculated using formula after formula. 

My total for the two columns is perfectly fine, all I need to do is, combine these totals into a new column.

Please see the images:

For the last column, I simply add the two:

Please let me know if I am doing something wrong, or if this is not possible.

Another thing is calculated percentage. I guess the answer to the above would mean the same thing for below:

Trying to do simple division, and it's just wrong.

Any advice or tips will be greatly appreciated.

Thanks, 

Thanks, 

[ToanDN]

Add another calculated value parameter that sum the two columns. Make sure all of them using the same unit type.

For percentage, tick percentage button instead of formula for the calculated value parameter.

[hashah935ZJ]

Hi @toan

Thank you for the reply! 

Isn't the 3rd Column I have 'Total units in store'  calculated value parameter? That third column is telling A+B to give me C. (Sorry if I misunderstand - total noob)

As for the percentage, I don't have any options other than selecting Grand total?

I want to be able to divide Total Units Apparel by Total Backroom Units

Thanks for your help! 

[SteveKStafford]

Have a look at this The Revit Kid's video, it might help you sort this out.

[hashah935ZJ]

Just to add on the above...
I'm trying to do calcs on the totals:

Thanks, 

[Mike.FORM]

In you schedule do you have grand totals checked in the sorting tab?

And then in the formatting tab have you set each of the parameters to calculate totals?

[hashah935ZJ]

Hi Mike,

Yes and Yes to both of your questions.

[ridantuo]

SALES FLOOR OPTIMUM UNITS:

Total Units  Apparel / Total Backdoor Units = 1860 / 2540 = 1,20

So isn't the math wrong if you want % so *100 is missing?

Not sure what the goal is and what units these are?

Like ToaND said: "--Make sure all of them using the same unit type."

[hashah935ZJ]

Hi @ridantuo , 

Thanks for the reply.

The goal is simple: 10 /20 = .5

Similarly:

1860/ 2540 = should equal .73

But in Revit, it's showing 13. 

Why? It should be a decimal number...

or in the formula, do I have to specify that I want calculations done from the total? 

I'm just confused.. 

[ridantuo]

Yeah, I totally goofed there myself it seems 😁

The 13 is weird tho 🤔

EDIT: Is there anything hidden on the schedules or is that all of it? And maybe this can help:

https://forums.autodesk.com/t5/revit-architecture-forum/furniture-schedule-calculate-the-ratio-of-to...

[hashah935ZJ]

@ridantuo it's all good haha.

And yes, there is a lot of stuff hidden lol. 
Maybe that's the issue? Do i have to remove some items that are hidden? not sure..

[Mike.FORM]

I'm pretty sure you are getting 13 because Revit does calculated parameters weird when "itemize every Instance" is unchecked.

It is doing the calculated parameter as if "itemize every instance" is checked and then adding all those totals together.

Here is a schedule with "itemize every instance" unchecked.

Here is the same schedule with "itemize every instance" checked.

Length / Height is a calculated parameter and in the first one it is adding up the values seen in the second table not doing a calculation on the totals of 38700 / 12700 which should be 3.04724.

The more items in the schedule the further away the calculated parameter will get from what you expect.

[hashah935ZJ]

@Mike.FORM 

I think you are correct and that's exactly whats happening.

So... with that being the case, do we have a solution? or we're just stuck here?

Thanks,

[Mike.FORM]

I do not think there is a way to get the calculated parameter to work as you would expect.

Even if you turn on grand totals in the sorting/grouping tab the same issue happens with those.

Someone else might know of a way to do it by adding a whole bunch of helper parameters but I do not know unfortunately.

[TripleM-Dev.net]

Hi @Mike.FORM,

FYI, formulas are always calculated on the individual elements never on grouped/summed values.

So "itemize every Instance" on or off doesn't matter what revit is concerned (Whished there was a option to calculate on the actual visible/calculated value and not the underlaying element value)

I's possble to calculate with summed results, but you will need 2 or 3 additional columns just to calc.

You need to set the summed value equal to 100% and then back to how much the elements value is %-wise of the total (percentage formula usage + correct grouping).

If there can be elements with a value of 0, then it gets tricky, and you need to convert first it to a really small value, like 0.00001, else you will be dividing by 0 and will not be calculated.

I've setup several schedules as described above, but it's a pain to maintain. I've stepped over to the API to pull the info from simple schedules and pass the calculated values over to other element where we can calculate with single elements.

- Michel

[Mike.FORM]

I do agree in general with how Revit deals with the grouped/summed values but when it comes to percentage values there should be a way to treat it differently.

Even if you have grand totals turned on it still sums the percentage values instead of using the grand totals of the respective fields in the formula and performing the operation.

[TripleM-Dev.net]

Here's a sample with the 4 walls:

 In red the additional columns (in this case 2 per field, because I don't need to worry about a 0-value, as each wall will have a length and height > 0)

Above the same schedule with all items, for this to work the schedule has to be set to Calculate totals.

First we take the percentage of the total Lengths

Field: total_length_percentage:

Field: total_length_value, this is a Length calculate field, with the formula: Length / total_length_percentage

And this is then actually the total sum of all length.

Same trick for the Height.

And the field: Length / Height will have as formula: total_length_value / total_height_value

This field can't be set to a calculation, because then it will sum 3 * 4 = 12.

Some some basic calculations like this it's doable, but for multi grouped summed values this will become a nightmare to create/manage.

Hope it helps.

- Michel