Soma retornando valor errado

[mxell]

Bom dia,

Tenho uma tabela e um KPI somando valores. A soma está resultando em valor incorreto.

QLIK

Excel: (valor correto)

O que pode estar ocorrendo?

[Instavini]

poderia compartilhar a formula do seu KPI por favor

[hic · Accepted solution]

The Qlik engine does not calculate the sum of rows. It calculates the total sum, independent of "Segmento". 

So, if a dollar belongs to more than one segment, it will NOT be counted twice in the total. In your case, you probably have approximately 200,000 $ that belong to more than one segment.

See https://community.qlik.com/t5/Design/Totals-in-Charts/ba-p/1464797 

[mxell]

sum([vl-merc-liq]+[vl-icmsub-it]+[vl-ipi-it])
+
sum([vl-frete]+[vl-seguro]+[vl-embalagem])
+
sum(icmsst)