addling calculated total column

[dlstrawn]

I have a column that needs to show in the total line for a grid, but it is calculated from the other total amounts, not just a straight total of a column (i.e. % spent of the total row…)? Any way to do this?

[Johnny Major]

Hi David,

You could create a calculated column that does the calculation per row then perform a summary on that column

Otherwise we don’t have a way to to summarize a column and add additional calculations

Thanks

[dlstrawn]

my data source is a free format sql – any way to add a calculated column in that case? Here is the column…

((dm.curenc + dm.ytdspt) / dm.budamt * 100) AS pctsptds

[sean.lanktree]

Isn't that already your calculated column? Is it not allowing you to add that?

[dlstrawn]

the calculated column is showing in the grid rows as a percent spent. The problem is when I total that column, it adds the percentages together in sum... I need it to do the percentage calculations on the total row to get an overall percent spent... make sense?

see attachment... screen shot.docx

in other words, I am trying to add a calculated column/field to the total line...

[sean.lanktree]

This is not currently possible. We will add this to our feature list. It will likely be the ability to add your own custom "renderer" to return the value.