Calculate percentage

Hi,

I’m still not so familiar to the nodes and their functions…
I would like to calculate the percentage of the OTD (when the actual time is > = planned time)then it is ontime.
Which Node should I use so I could calculate the percentage?
(When actual_eta is bigger than planned_eta than its ontime and needs to divide all the bookings)


I have a column, which contains wether it is ontime or delay. I thought about to count the value but I have problem knowing how to count only the number of ontime and divide it with all rows)

thanks in advance!
truck.knwf (3.6 MB)

Hi @ppeng , you can use the Math Formula node to calculate the percentage.

2 Likes

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