Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

GROSS PROFIT

I have more than 100,000 lines showing invoice data. Few lines are shown below.

Invoice NOPurchase AmountSold Amount
INV001100125
INV002125130
INV003140148
INV004150165
INV005200250

I want table as below

Invoice NOPurchase AmountSold Amount% Profit
INV00110012520.00%
INV0021251303.85%
INV0031401485.41%
INV0041501659.09%
INV00520025020.00%
TOTAL71581812.59%

Kindly help me.

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

1 - sum(PurchaseAmount) / sum(SoldAmount)

View solution in original post

23 Replies
Not applicable
Author

Use this:

([Sold amount]-[Purchase Amount])/[Sold Amount]

Go to Number Tab:

Select Fixed to: 2 Dec

Tick on checkbox "Show in %age"

Not applicable
Author

This is already done and I am getting TOTAL for "Purchase Amount" and "SOLD AMOUNT" but not getting total for % PROFIT.

Not applicable
Author

Hi,

I think Erika giving the correct answer, if not that is exactly, what you want?

A little more information would be good.

Regards

Gabriel

Not applicable
Author

I want total at bottom for Purchase Amount, Sold Amount & % Profit.....

Not applicable
Author

If you are using a pivot table, you need to go to presentation tab and click show partial summaries for the top dimension, or change the table to a straight table

Not applicable
Author

Use:

if u r using Pivot table:

Sum(

([Sold amount]-[Purchase Amount])/[Sold Amount]

)

Not applicable
Author

Thanks for your response. Sorry but I am not getting TOTAL by using PIVOT TABLE for % Profit

its_anandrjs

Hi,

See the attached sample for clearity

And suntotal of Purchase Amount, Sold Amount & % Profit.....

By the help of straight table you get this in pivot it is not possible for the expression, there you do only on dimensions.

Regards

Anand

Not applicable
Author

Can u upload ur Sample App.