Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

% of Totals

I want in my last column to have the pourcentage of 'Total Cost' for each rows...

Total Cost = Quantity * Actual Cost

1 Solution

Accepted Solutions
sunny_talwar

Try this:

=Sum(Quantity*ActualCost) / Sum(TOTAL Quantity*ActualCost)

View solution in original post

4 Replies
sunny_talwar

What is your exact expression you are using for Total Cost?

Not applicable
Author

sum(Quantity*ActualCost) / [Total Cost]

sunny_talwar

Try this:

=Sum(Quantity*ActualCost) / Sum(TOTAL Quantity*ActualCost)

Not applicable
Author

Perfect man