I am trying to do a specific count if statement where if an item in column D is counted by a dummy date. So in theory on 9/14 I had these many rail cars showing a status of A and and P, then subtract all the railcars that have P from A to show me the remainder. That remainder should eventually be a running total
test wahpeton.xlsx (785.2 KB)
Hi @Einayyar , so… what is your question?
And what’s 9/14? And which of the multiple date columns are you referring? And what are you subtracting? I don’t see any amount of railcars. Maybe none of these questions are relevant depending on what you are trying to do.
Could you provide a workflow and expected output so we can further assist you?
Hard to tell exactly what you are working toward… The way I read it initially, you could try a Rule Based Splitter node to separate your rows based on criteria, then create a new column with +1 on top branch and -1 on bottom branch, then concatenate, then moving aggregation to get your running total? Just a shot in the dark on your aim…
Sorry for the delay on this. This ask is no longer needed.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.