Question

Calculation Based of Field in collection section.

Forms Version 10

Updated April 27, 2020

asked on April 22, 2020

Hey everyone,

First wanna say sorry if this is a basic resolution. We just purchased Laserfiche so this is all new to me. Typically more of a sysadmin role, and never really did much javascript in my time.

Our travel form is formated as a bunch of collection points. We have several people who Travel daily fulfilling different rolls with different budgets (education company so its a bit of a nightmare).

Currently, I have everything calculating correctly inside the collection field. What I am struggling with is taking the totals outside those for a "grand total" if you will.

I can get the grand total box to add all the Trip total boxes easily. What I would want is a grand total for budget code 315, 316, 317, so on and so forth. Some people have like 8 codes.

I'm thinking i would just populate a table down there based on the input from budget org, but I'm not sure how to accomplish that. Doing some digging on my own, but figured why not ask here too.

Thanks in advance!

0 0

Answer

SELECTED ANSWER

replied on April 23, 2020

You could try having another table with columns

Budget code | sub-total
(pulled from SQL as new rows) | =sumif( BudgetOrg, index ( budgetcode, row()) , numOfMiles)
315 | =sumif( BudgetOrg, 315, numOfMiles)
316
xxx
yyy

Where the sumif above checks the range BudgetOrg from the initial table, compares it against the value from Budget Code pulled from SQL in table 2, then sums the NumOfMiles from table 1.

0 0

replied on April 27, 2020

Yeah, that's a fantastic idea! Thanks! Got a working model-ish. Just need to make it pretty now. TY

0 0

Replies

replied on April 22, 2020

Update, used sumif to accomplish it. We still need to figure out how to variablize it as those budget codes will be pulling from SQL.

0 0

You are not allowed to follow up in this post.

Question

Question

Calculation Based of Field in collection section.

Answer

Replies

Sign in to reply to this post.