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
Hello @VASILEIOS_PAPAIOANNO
I would use SWITCH()
for this
Switch([Reason],
"1", [Balance1],
"2", [Balance1] + [Balance2]
"3", ([Balance1] + [Balance2]) - [Balance3],
0)
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โฆ
Reason Amount Balance
โABCโ $ - 200 $ - 200
โDEFGโ $ 1.000,00 $ 800.00
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |