How do I get a total (Calculated Estimate Margin) to appear with totals?

[Anonymous]

I have a Sales Order Sheet set up and I am getting information totaling for my Sales Order values and Estimate Costs. But what is not showing up is the calculated result of my Calculated Estimate Margin. They appear line by line not problem, but I have checked off under Chart Properties/Expressions/Total Mode=Expression Total.

I have attached screen grabs of my sheet, chart properties and expression definition. Any help to have the total result appear under Cal Estimate Margin would be greatly appreciated.

[#2]

Chris,

Expecting total for a percentage column is not possible in any of the charts. We can only calculate total for numbers or points.

Hope this helps

[vishsaggi · Accepted solution]

Not sure but try this? If not can you upload a sample app to work on?

Calculate %Estimate Margin

= Sum( (([So Value] -  [Est Cost])/ [So Value]))

[Anonymous]

Do I make this change in the expression edit (definition)?

[vishsaggi]

Yes.

[vishsaggi]

Did you try the expression? Is it working?

[Anonymous]

It is, Thank you. I would like to ask another question about creating a way in NPRINT for a word doc to show a report by subtotaling Monthly information. Would you be able to help, I can post a new question

[vishsaggi]

Ahh! Not really expert in Nprinting. But would try, post it, some one else might help too.