Schedule Footer Formatting

Schedule Footer Formatting

ashdon.mcfallVT2XN
Contributor Contributor
926 Views
9 Replies
Message 1 of 10

Schedule Footer Formatting

ashdon.mcfallVT2XN
Contributor
Contributor

Hi all,

 

Is there a way to format footers at all? I would like the subtotal shown in the attached to be underneath the occupancy count (Column E) instead of at the bottom of each for Column A

 

 

0 Likes
927 Views
9 Replies
Replies (9)
Message 2 of 10

ToanDN
Consultant
Consultant

Format Occupancy to Calculate Totals.

0 Likes
Message 3 of 10

barthbradley
Consultant
Consultant

Is Occupancy the in-built Text Parameter?  

0 Likes
Message 4 of 10

ashdon.mcfallVT2XN
Contributor
Contributor

Sorry i should have described how the schedule is producing its results!

 

So the 'Occupancy' column is actually 'Count'  - The number of which is calculated from a specific chair family (family field is hidden)

 

The schedule is filtered by Room (Department column) first, then family (chair) 

 

Thanks

0 Likes
Message 5 of 10

barthbradley
Consultant
Consultant
0 Likes
Message 6 of 10

ToanDN
Consultant
Consultant

Format Count field to Calculate Totals and set the footer to show Title and Totals only.

0 Likes
Message 7 of 10

barthbradley
Consultant
Consultant

Post your File here via Attachment in Reply Post.  

0 Likes
Message 8 of 10

ashdon.mcfallVT2XN
Contributor
Contributor

I cant seem to format the count field 

0 Likes
Message 9 of 10

ashdon.mcfallVT2XN
Contributor
Contributor

This looks promising! Il take a look at this a bit later and let you know how i get on. Thank you for sharing the link!

 

0 Likes
Message 10 of 10

ToanDN
Consultant
Consultant

Add a calculated value of parameter, enter 1 in the formula, format it to calculate totals, and use this parameter in lieu of Count.

 

ToanDN_0-1671551614248.png

ToanDN_1-1671551642744.png

ToanDN_2-1671551690362.png

ToanDN_3-1671551713527.png

 

 

 

 

0 Likes