Accuracy- Acuracidade

[visouzainvent2000]

Hii guys,

I need show a KPI of accuracy of values but I have a doubt about how can I show a accuracy of NET values.

Ex:

I have a stock of $ 1.000 and I difference  the (+100) dóllars in my stock, but I want that my KPI don´t exceed of 100%.

How can I make this formula ?

I'm using that "fabs((Sum(Amount)+Sum([Valor Dif_LOG_NET]))/Sum(Amount))" but on the months that I have positive differences, my graphic of chart goes wrong.

Boa tarde pessoal,

Minha dúvida é em relação à acuracidade de valores que excedam o meu estoque contábil.

Ex: possuo um estoque contábil de 1000 reais e encontro 1100 no físico, como demonstrar essa diferença de 10% sem ultrapassar os 100 ? 

[StarinieriG]

Hi 

try with this expression:

If(Sum(Amount)>Fabs(Sum([Valor Dif_LOG_NET])),Sum(Amount)+Sum([Valor Dif_LOG_NET]),Sum(Amount)*If(Sum([Valor Dif_LOG_NET])<0,-1,1))/Sum(Amount)

[visouzainvent2000]

Hi,

thank you soo much for answering me.

It's help me to find a way, but not solved my problem 😞

On my graphic of charts, the months with positive differences keeping exceed 100% (Ex. 100,12%)

Can we talk on Outlook ?

[StarinieriG]

Hi,

maybe you could try this expr:

If(Sum([Valor Dif_LOG_NET])>0,1,
If(Sum([Valor Dif_LOG_NET])<0 and Fabs(Sum([Valor Dif_LOG_NET]))>Sum(Amount),-1,

(Sum(Amount)+Sum([Valor Dif_LOG_NET]))/Sum(Amount)))

Let me know if it works

[visouzainvent2000]

Hi,

Can you help me yet?

I still can´t solve my problem, the formula it´s wrong to the qlik 😞