Delta function in QlikSense

[Anonymous]

Hi, I'm stuck in a Delta% function in QlikSense.
Delta is calculated as a difference between 2 quantities, which was easy to derive.

Delta% has the following formula from Excel i.e (Delta/Sum of all +ve Delta) but I'm not able to generate any values.

Below is the expression I'm trying to implement -

(Sum({<[KPI Name]={'#Buy Lead Conversions (PH)'},flag={'BMCTotalITM'},Year={'2017'}>}[Targets])-

Sum({<[KPI Name]={'#Buy Lead Conversions (PH)'},flag={'BMCTotalITM'},Year={'2018'}>}[KPI Value]))

/

(Sum({<[KPI Name]={'#Buy Lead Conversions (PH)'},flag={'BMCTotalITM'},Year={'2017'}>}Targets)-

Sum({<[KPI Name]={'#Buy Lead Conversions (PH)'},flag={'BMCTotalITM'},Year={'2018'}>}[KPI Value]))

Pls do help.

[dwforest]

Denominator needs to be:

(Sum({<[KPI Name]={'#Buy Lead Conversions (PH)'},flag={'BMCTotalITM'},Year={'2017'}>} TOTAL Targets)-

Sum({<[KPI Name]={'#Buy Lead Conversions (PH)'},flag={'BMCTotalITM'},Year={'2018'}>} TOTAL [KPI Value]))