Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fabianaiglesias
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
rajeshthakur292
Contributor II

Re: I need help with an e- result

Hi fabianaiglesias

Please check if the attached app shows the correct result.

Thanks,

RT

4 Replies
Employee
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?

fabianaiglesias
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...

rajeshthakur292
Contributor II

Re: I need help with an e- result

Hi fabianaiglesias

Please check if the attached app shows the correct result.

Thanks,

RT

fabianaiglesias
Contributor

Re: I need help with an e- result

Thank you very much!