# Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Highlighted
New Contributor II

## 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.

Tags (1)
1 Solution

Accepted Solutions
Esteemed Contributor III

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

7 Replies
Not applicable

## 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

Esteemed Contributor III

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

New Contributor II

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

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

Esteemed Contributor III

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

Yes.

Esteemed Contributor III

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

Did you try the expression? Is it working?

New Contributor II

## 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

Esteemed Contributor III

## 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.