Combine two lines based on condition

[rafatomillero]

I want to combine the lines where there is a 5 and below a 0.242 to show 5.242. Likewise, I want to combine the ones that are a 9 and below 0.242 to show 9.242. How do I achieve this?

[grazitti_sapna]

Hi @rafatomillero, is this 0.24 a constant or it could be any decimal number?

[rafatomillero]

Hi @grazitti_sapna, it would be a constant. The picture I attached is all the data I have.

[Emmanuel_G]

Hi @rafatomillero ,

Find solution attached

[binuacs]

@rafatomillero one way of dong this

[grazitti_sapna]

@rafatomillero, my workflow contains two methods one is dynamic and one is based on constant.

Feel free to use any of them as per requirement.

Thanks!

[rafatomillero]

Hi @Emmanuel_G , that's great! but in the New Field how do you delete 5 and 9 where below [Premium Tax Rate Applied] = 0.0242? I don't need them to show in the data. The last two 9 are fine to show because they do not have 0.0242 below.

[Emmanuel_G]

@rafatomillero 

Attached solution desired

    

[grazitti_sapna]

@rafatomillero, updated workflow if it helps.

Thanks!

[binuacs · Accepted solution]

@rafatomillero updated the workflow