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?
Solved! Go to Solution.
Hi @rafatomillero, is this 0.24 a constant or it could be any decimal number?
Hi @grazitti_sapna, it would be a constant. The picture I attached is all the data I have.
@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!
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.