Assign subtraction of two KPI values to 3rd KPI

[agni_gold]

Hi Friends,

I am tring to calculate one KPI value using substraction of two ther KPIs , and written below expression ,

sum(TOTAL{$<_PFlag={'$(vPriorityFilter)'},VARIANCE_BASE_SK={'$1'},FINANCIAL_ACCOUNT_KEY=,ACTUALITY_SK={'AC'},FINANCIAL_ACCOUNT_KEY={'928199'}>}$2)

-

sum(TOTAL{$<_PFlag={'$(vPriorityFilter)'},VARIANCE_BASE_SK={'$1'},FINANCIAL_ACCOUNT_KEY=,ACTUALITY_SK={'AC'},FINANCIAL_ACCOUNT_KEY={'928130'}>}$2)

And my Dimension is FINANCIAL_ACCOUNT_KEY , when i am using this expression in my straight table , then i am not getting my third account 901079.

Is any other method , plz suggest.

[annafuksa1]

if you are using account number in set analysis only this accounts will be used. so you need to not use at all account number or all that need to be used.

Anna

[agni_gold]

I need to calculate dynamically at run time for the calculation based on other account.

[agni_gold]

Attaching the sample file , here i need to show Sales Volume KPI also in chart , but with the help of set analysis.

[annafuksa1]

so do not use account number in your expression.

you are using a lot of fields that are not in your model and a lot of parameters.

[agni_gold]

gwassenaar‌   any help plz.

[Gysbert_Wassenaar]

There is no sales volume. The amount value is Null for the record (Sales Volume, 901079)