Negative values not showing in Math Formula percentage calculation

[raozaid]

Hello,

I’m using the Math Formula node to calculate the percentage change between two columns. In some cases, the result should be negative, but the output only shows 0 or positive values.

What should I adjust to allow negative results?

Thank you.

[mlauber71]

@raozaid

the result should be negative, but the output only shows 0 or positive values.

Maybe you can provide an example where this supposedly happens

[raozaid]

@mlauber71

Maybe you can provide an example where this supposedly happens

Sure, here’s an example:

• Column1 (PreviousValue): 200

• Column2 (CurrentValue): 150

Using the formula:

(($Column2$ - $Column1$) / $Column1$) * 100

I expect the result to be:

(150 - 200) / 200 * 100 = -25%

But instead of showing -25, the output just shows 0 (or sometimes a positive number).

[ActionAndi]

Hmm, in 5.5.1 this works:

[MartinDDDD]

@raozaid

Sure, here’s an example:

• Column1 (PreviousValue): 200
• Column2 (CurrentValue): 150

Using the formula:

(($Column2$ - $Column1$) / $Column1$) * 100

I expect the result to be:

(150 - 200) / 200 * 100 = -25%

But instead of showing -25, the output just shows 0 (or sometimes a positive number).

wow that is really strange - can you post a screenshot of this and share the workflow so we can try and reproduce?

[daniela_digles]

With KNIME 5.5 I get the correct result (-25).