Balance. What type of Expression can I use?

[VASILEIOS_PAPAI]

Reason 1 . Amount 1. Balance 1
Reason 2 . Amount 2. Balance 1+2
Reason 3 . Amount 3. Balance (1+2) -3

What type of Expression can I use ?

Thank you

[MultiTech]

Hello @VASILEIOS_PAPAIOANNO

I would use SWITCH() for this

help.appsheet.com

SWITCH()

Chose-one conditional evaluation

---

Switch([Reason], 
  "1", [Balance1], 
  "2", [Balance1] + [Balance2]
  "3", ([Balance1] + [Balance2]) - [Balance3], 
0)

[VASILEIOS_PAPAI]

Thank you very much. If you can make a video or a post for, how when submit data from a form to a table and the same time some data or all data goes to another table . Thank you very much.

By the way I like your hat…

[VASILEIOS_PAPAI]

Reason Amount Balance
“ABC” $ - 200 $ - 200
“DEFG” $ 1.000,00 $ 800.00