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

Question

Question

Sumif with wildcard is not working

Forms
Updated July 7, 2021
asked on July 1, 2021

I have a table with a GL account and a sub-total in each row.  I'd like to sum the sub-totals in a field that is outside of the table. The following formula works in Google Sheets, so I'd hope that it would work in LF Forms as well since they both use the OpenFormula standard.

However, this formula in my form does not return a value:

=SUMIF(Expenses_Table.GL_Account,"*8527*",Expenses_Table.SubTot_1)

 

Thoughts?

 

 

0 0

Replies

replied on July 7, 2021

You will most likely need to use the INDEX() function in order to specify a row and column to pull the data from. You can use the ROW() function to work in conjunction with INDEX to get the current row. It may be helpful to see some of the validation messages or console logs that Forms returns.

0 0
replied on July 7, 2021

I appreciate the response, but since I'm summing rows that meet the criteria I don't believe Index() is needed.  As a work-around, I added another field that contains the value I'm trying to use in the SumIf criteria in order to avoid the need for using a wildcard; this approach works very well, but I wanted to leave this question open to determine if wildcards are supposed to be supported in Laserfiche's implementation of OpenFormula or not.

 

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...