Rule engine or Math formula..?

[sundipsandy]

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

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

[Fabien_Couprie]

For inspiration :
test_formula.knwf (11.5 KB)

[ScottF]

Hi @sundipsandy -

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

How to write a good post

Before we go into this subject: first, and absolutely foremost: always search before posting your question. Your question may have already been posted and answered in the forum. Searching can help you save loads of time and effort! Ok, with that out of the way, let’s go: Writing a good post Let’s say you come to the forums because you need help with an error. Logically, a good title for your post would be “Help with an error”, right? Well…wrong! Put yourself in the shoes of the person browsin…

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

[sundipsandy]

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

[Fabien_Couprie]

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.

[sundipsandy]

Please provide the syntax for above in column expressions…

[Daniel_Weikert]

Hi,
have you read @ScottF reply? Just kindly asking.
Maybe you like also to provide what you have done so far. You can upload your workflow with demo data here in case you want to do that. That makes it easier for the community to help
best regards