Schedule Table total total

[Mr Cory]

Hey everyone!

Well i no longer need a hair cut cos its been torn out lol.
Heres my problem, im working with a schedule table and all i need is to take the total from one column and find the percentage of the total from another column but do you think i can figure it out!? any help would be greatly appreciated!!

[Mr Cory]

Or if had another table which displayed the percentages

[leothebuilder]

I noticed you have ADT2007.
Does ADT2007 allow you to add a formula column to your schedule?
I have ACA2008 and this version does have that function.
If you have this capability in 2007, add a formula column and create a formula
to calculate the percentage between the two other columns.

Leo

[Mr Cory]

Yeah it does have formulas, i did have this set up which was fine but then i needed to get the total percentage and instead of getting an average of the percentages i was getting a total e.g. 897% lol

Basically i have two coulumns which i have set to display to totals of each column. It is these totals that i need to find the percentage of, not the individual table rows. Sorry if im not explaining it very well

[leothebuilder]

Don't think that is a possibility creating a formula for just the totals of the two columns.
Not in schedules anyway. It is possible in tables. One for the wishlist.

[Mr Cory]

Yeah i'd say it is. Owell, i made a block with attributes and formula fields that does the trick. Thanks for your time