4 Replies Latest reply: May 6, 2018 5:23 PM by Fabiana Iglesias

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

• ###### 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?

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

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

Please check if the attached app shows the correct result.

Thanks,

RT

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

Thank you very much!