Formula bank balance

[Virginie]

Hello,

I have a problem with a formula linked to a look up. I have a table with my banking transactions (linked to my bank) and another with forecast expenses. I did a look up to get the bank balance and I made a formula (Bank balance-expenses) for the first line the calculation is correct but for the other lines it does not give me the balance calculated above. Do you have any ideas to solve this problem?

[Dimitris_Goudis]

Hey @Virginie, 

Did you try to add a rollup instead of lookup? 

Thanks 

Yours sincerely,
Dimitris Goudis