Schedule running in totals to the right

[johanSR]

Hi all.

I would just like to know if anyone had experience in creating a schedule like this before?

I would like to have the amounts next to descriptions, per floor, and then a total of each item at the end... As per the pic.

Operating system used: Windows 11

[B_Migito]

Hey Johan,

As far as I know, you won't be able to get exactly that type of schedule with the native tools but you can get pretty close 

If you use these options (1) with the flag on ID and sum on quantity 

 

You can get the items and their quantities per floor like so (2)

 

If you need to add description, you simply add in (1) the description/personalised text between the quantity (Quantité in my image) and 2D preview (Prévisualisation plan 2D in my image) 

That's about as close as I can get it

[johanSR]

Thank you!!!

I thought so...

I set it up like this so far, but is there a way I can merge the highlighted cell/columns into one, as they would display the same info/specs...

[Mathias Jonathan]

You can also use the "brute" force: as many properties as there are stories, a formula for each property (set to number) that verifify if the element is in the story (=1) or not (=0).

The merged properties should give you a result similar to your example.

[johanSR]

Mathias...
Could you repeat that in English please... LOL

I don't think I understand what you mean. Would that apply to the picture preview as well?

[Mathias Jonathan]

[johanSR]

Mathias. Thank you!

This seems like I need to figure a bunch of stuff out before I can get to whta you've done... I don't even know how you got to the second picture settings...

But i'll try on Monday again. Thanks!!!

If you can, would you be able to send  scheme setting setup as well?

[B_Migito]

You get to the second picture by going : 

>Options

>Property Manager

[johanSR]

Hi Mathias.

I've been trying to get it to work, but I couldn't get it...

Here is my setup...

I assume I create one for each floor? And how does the expression work for each floor?

That option is greyed out...

[Laszlo Nagy]

Try to click the Σ icon for the Quantity field in the Scheme Setup Dialog, so it changes to Σ1. That way, it will summarize the number of those items instead of summing the quantity.

Or, maybe you need to create an additional Property called "Total" whose value would be "1" for all elements regardless of which Story they are on (each element counts as 1 in the Total, right?).

So, you would not rely on the totaling function of the schedule; you would do the totaling yourself with this Property and just display the value of this "Total" Property in the Schedule. This is basically what your image shows in your original post - an additional Schedule Field called "Total". This is how you can create it.

Please let us know if either of these worked.