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

Question

Forms - Cloud - field calculation displays error if referenced table has no rows

Forms

Updated April 2

asked on March 31 • Show version history

Hello,

I have a form with a field that performs a basic SUM on a column in a table. I would prefer that this table have a minimum number of rows of zero. However, I can't get this field outside the table to accept the table having zero rows. I've tried a few different IF formulas using Table.Column<>"" or INDEX(Table.Column, 1)<>"" but can't seem to get anything to work. Any ideas on how I can do this?

Screenshot to provide some context. The "Grain Total" field is trying to calculate the sum of the Amount Due column above it.

Thanks!

0 0

Replies

replied on March 31

Not sure if this would actually work, but you might try:

=IF(Table.ROW()=0,"",(existing equation goes here))

IF(Table.ROW()=0 should return true when the field is outside of the table. This should only be true when there are no rows, which will make your sum field value "". As soon as a row is added, it will use your sum equation instead.

0 0

replied on April 2

Hi Kevin,

Trying this out and getting syntax errors. If the variable name for my table is Ticket_Summary, is this supposed to look like the following?

=IF(Ticket_Summary.ROW()=0,"",SUM(Ticket_Summary.Amount_Due))

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked March 31
Updated April 2
34 views