Valid if with difference table

hi dear
i build to a application, with appsheet and form input
but i want to use formula in field valid if
i use this formula
[_THIS] > keuangan[jumlah_keuangan] + catatan2[jumlah_pemasukan]
but my project display a error


even though my table is all number, can you help me for this problem?
3X_d_5_d56e05e9c931fe2d04374af0e454f6a88d681f94.png
I want when the user adds data here, an error message will appear because the data entered must not exceed the amount of the โ€œ[jumlah_keuangan]โ€ table added to the โ€œ[debit]โ€ table

0 2 118
2 REPLIES 2

Steve
Platinum 4
Platinum 4

keuangan[jumlah_keuangan] and catatan2[jumlah_pemasukan] are each table-column references, which each produce lists of values, not singular values. Can you describe in plain language what your comparison is trying to do?

See also:

thanks, i will try it

Top Labels in this Space