# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## I need help with an e- result

Hi guys,

I have problems with some formulas that result in e-, which is wrong
I've had many attempts trying to discover what is wrong without success
I would appreciate some help ...

1 Solution

Accepted Solutions
Contributor II

## Re: I need help with an e- result

Please check if the attached app shows the correct result.

Thanks,

RT

4 Replies
Employee

## Re: I need help with an e- result

Could you expand a bit more on where in your app you are having problems, and the expected result is?

Contributor

## Re: I need help with an e- result

Yes Toni, I´ll explain better:

I have this table and I´ll focus on the data in the red line:

these data are obtained from the following formula:

Ciclo de inventario = \$(vDiasAño) / \$(vRotacionInvAño)

In january the result should be 31 / 0.34 = 91.18 instead of 6.8489..e-11

I put the formulas for:

\$(vRotacionInvAño) = \$(vCostoVentasAño) / \$(vInvAño)

\$(vCostoVentasAño) = sum({<IDCodigo={'601.01*','601.02*','601.03*'},Año={\$(vAño)}>}Dinero)

\$(vInvAño) = sum({<IDCodigo={'100.01.009.001*','100.01.009.002*'},Año={\$(vAño)}>}Dinero)

where all the results are correct

I really don´t figure out what is wrong...

Contributor II

## Re: I need help with an e- result

Please check if the attached app shows the correct result.

Thanks,

RT

Contributor

## Re: I need help with an e- result

Thank you very much!