Skip to Content
0
Former Member
Jan 07, 2008 at 06:45 AM

Formula %A does not deliver right result for some ranges

24 Views

Dear experts,

I have a formula of percentage which should show key figure in %.

So, I use formula: KF1 %A KF2.

However, I found that in some ranges the result will be shown as 0 (if it falls in range -0.4 to 0.4)

data example:

KF1 : 3

KF2 : 500

Formula : 3 %A 500

Result : 0.6 (this value is shown correctly)

KF1 : 2

KF2 : 500

Formula : 2 %A 500

Result : 0.3 (this value is shown as zero)

So when the result falls in some range, the value is not shown correctly.

Any hints of why this error may occured?

Rgrds,

-S-