You are viewing limited content. For full access, please sign in.

Question

total value calculate from table column

Forms

Updated October 15

asked on October 15

Hi,

I have two tables and both table have debit/credit dropdown field where i need to use (SUM and SUB) formula in total debit amount and total credit amount in respective table which is separate field of each table. In first table, select first and second row as debit and third row as credit then first two rows will be sum and third row is sub where i want to get total debit amount from two rows - third row. Is there any workaround to get the total debit an credit values. Please refer below table screenshot.

0 0

Replies

replied on October 15

If you are totalling up the debits and credits into two fields outside your table, you should be able to do this fairly easily with the SUMIF formula.

=SUMIF(table_variable.type_field_variable, "Debit", table_variable.amount_field_variable)

=SUMIF(table_variable.type_field_variable, "Credit", table_variable.amount_field_variable)

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked October 15
Updated October 15
39 views