Thank you for your reply. I cannot post the data file as it has too much sensitive data.
I tried using the same expression. In the example I posted I literally write ="Impact B" for the "subtract" waterfall portion. but it gives me blank as you can see, it should give me -2,688. It is not capturing "Impact B" in the waterfall chart.
If possible to connect via phone (I can call) I can explain better. Other wise I hope I was clear enough.
appreciate you finding a solution please!