I need help with an e- result

[Anonymous]

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

[ToniKautto]

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

[Anonymous]

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

[Neymar_Jr · Accepted solution]

Hi fabianaiglesias

Please check if the attached app shows the correct result.

Thanks,

RT

[Anonymous]

Thank you very much!