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

Sum formula

Like adding 2 columns, hiding in the column "Month", the reference "Overhaul ', to bring me the percentage?

Sum columns [Maint.] = {'Planned'} <> [Mês] ('Overhaul') [TotalPrice)/Sum columns [Maint.] = {'Planned','Unplanned'} <> [Mês] ('Overhaul') [TotalPrice)/

teste1.JPG

1 Reply
vinieme12
Champion III
Champion III

Try


=

Sum ( {<[Maint.] = {'Planned'} , [Mês]  -= {'Overhaul'}  >} [TotalPrice])

/

Sum ( {<[Maint.] = {'Unplanned','Planned'} , [Mês]  -= {'Overhaul'}  >} [TotalPrice])

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.