7 Replies Latest reply: Mar 13, 2017 4:05 PM by Vishwarath Nagaraju

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

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.

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

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

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

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]))

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

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

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

Yes.

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

Did you try the expression? Is it working?

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

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

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

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