# Qlik Sense App Development

Highlighted
New Contributor III

## KPI calculation problem

Dear all,

I have the following challenge:

I have a table containing following fields Name, Area, Sum(Revenue) and Sum(Parts).

I want to form a measure of revenue and parts. And all Areas(A-F) should be divided by the value of Sum(parts) of area E.

Can someone help me with this formula please?

NameAreaSum(Revenue)

Sum(Parts)

Kennzahl Umsatz / Teile ("Bereich E")

Name1Area A100002
Name1Area B5000010
Name1Area C250005
Name1Area D300006
Name1Area E120000500240
Name1Area F10000020

Many thanks,

Felix

Tags (5)
1 Solution

Accepted Solutions
MVP

## Re: KPI calculation problem

Try this

Sum(Revenue)/Sum(TOTAL <Name>  {<Area = {"Area E"}>} Parts)

2 Replies
MVP

## Re: KPI calculation problem

Try this

Sum(Revenue)/Sum(TOTAL <Name>  {<Area = {"Area E"}>} Parts)

New Contributor III

## Re: KPI calculation problem

Many thanks Sunny, as I am just starting to work with Qlik I really appreciate your help.