Sumif and Conditional formatting ideas

Hello,

I am a beginner to Knime and am looking to use it for a workflow I have in excel.

My workflow uses sumifs to calculate one month’s value of a cost element as a % of four month’s value of the same cost element.

From this the conditional formatting analyses whether or not the 1 month is roughly a quarter of the total 4 month’s value.

If anyone has any ideas on nodes that they think may be helpful with this I would appreciate any steer on this topic.

Thank you in advance,

Sam

Hi @sammeredith, welcome to the forum.

Here’s a workflow that should get you started.

Conditional formatting isn’t really a thing in KNIME unless you’re going to be exporting to Excel. In that case, you’d use the XLS Coloured Writer node and specify your conditions.

3 Likes

Hello @elsamuel ,

Thank you very much for your support on this it is fantastic!

I will update you on how I get on with it.

Thanks again,

Sam

The Continental Nodes for KNIME provide many nodes with respect to Excel formatting:

Best,
Julian

Brilliant, thank you I will look into this too.

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.