# Rule engine or Math formula..?

The above picture formula
=if(B6>0, B6, 0) +B7+B5

And
= if(B6<0, B6, 0)

For inspiration :
test_formula.knwf (11.5 KB)

Hi @sundipsandy -

Please take a moment to review the guidelines for writing a quality post, and adhere to them. You can find them here:

Help us help you by providing the needed details. Copy and pasting screenshots and Excel formulas is likely to not get the results you want, even as helpful as this community is

5 Likes

if balance are positive must be reported as zero and if not need to subtraction with positive balance
ex;- 11,661,611.87 + 7,940,351.98 =19,601,963.9
=19,601,963 -1,170,126,545.91 =1,150,524,582.07

The post title is : rule engine or math formula ? You can obtain that with the â€śColumn expressionsâ€ť node as in the short example above : combination of a formula and an if then else structure. It doesnâ€™t solve your problem but give you an hint how to write formulas in Knime in a excel like mode.

1 Like

Please provide the syntax for above in column expressionsâ€¦

Hi,