I am trying to split rows where the Warranty column is not 20%, and then duplicate that row and just add in the correct amount (second set of columns below.) Any ideas would be welcome!
Solved! Go to Solution.
@ppatane what is the calculation of 20% based on Spent and Warranty? I mean how are you getting 20% based on Spent and Warranty?
Warranty / Spent
@ppatane One way of doing this
@binuacs The sample file I provided was much more simplistic than what I am actually using, but your workflow gave me the path I needed, I am very grateful! Grazie! I am now actually duplicating all the rows, filtering out the rows that are numbered 2 and have a correct 20%, and then will go to the rows that do not meet the 20% rule and do the necessary calculations I need on those rows and union it all back together. ☺