# How to find % of a range with respect to total column.

Hello,
I am new to this SW.
Context: I have imported a long Excel sheet containing power consumed by the machine. When the machine is on stand by, it takes a lot less energy.
Problem: I have sorted the data by colour and ascending order, but next I would like to find out what is the % of time the machine is in standby. I want to do this by setting the range of power it takes when in standby ( 0 to 3KW). So that next time I use this node on any excel, it will tell me what % of the total excel, the machine was on standby by checking the range I set.

Hi @sunilkr ,

Well come to the forum community!

I can say that you can use the group by node to bring some insights for you, as the max value, min value, sumâ€¦ with that result, you can compare, filter or make joins with the result to determinate it.

If you can bring a dummy example here as file, we can see and make some suggestions too, could you?

BR,

Denis

2 Likes

Energy 1.knwf (9.1 KB)

Here is the file. Could you show me an example of a solution on this workflow?

Math formula node can give you the total value of a column e.g. COL_SUM(Column Name). Then you can divide the value by the newly created column in a second math formula node
br

1 Like

Hi @sunilkr, welcome! Unfortunately the excel data hasnâ€™t been retained in your uploaded workflow because the excel sheet is located elsewhere on your pc, and the workflow has been reset.

Can you fully re-execute your workflow so all the nodes are green and then export it making sure that the â€śReset Workflowâ€ť option is not ticked, then upload it again.

thanks

1 Like

Energy.knwf (517.0 KB)

Unfortunately, I need a bit more detailed explanation to the solution.

Hi guys,

Thatâ€™s what he means and I put some extra calc that can be useful for you too.

Energy2.knwf (652.9 KB)

Thanks,

Denis

1 Like

Thanks. That helped. Definitely learned something new today.

2 Likes

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