straight table total %

[#1]

i cant seem to get the total to display correctly or at all.

The total % should = (capacity-demand)/demand

As you can see its displaying blank.

How can i get it to display the total expressed as a % ?

[#2]

Try:

 sum(Capacity-Demand)/Demand
//may even need something like this
(sum(Capacity-Demand))/Demand
//or play around with num
sum(Capacity-Demand)/num(Demand)

One of those combinations should work. QV needs more direction.

[rwunderlich]

You'll need to specifiy an aggregation for all the data involved. Like Jacob said, but for the divisor as well.

sum(Capacity-Demand) / sum(Demand)

-Rob

[#4]

dear all, i still cant get the correct % for all columns including the total column.

see picture below which shows the results from the different expressions you suggested

are there any other ideas for expression/settings that will enable the table to display correct % for all months + the total column?