Expand my Community achievements bar.

SOLVED

Calculate page subtotals in repeating dynamic subform

Avatar

Level 2

Hello,

I have a repeating subform that can span many pages, at the bottom of the list I have a grand total.......thats great

I would like to add a subtotal for each page of the repeating subform. How can I do this?

I have the following code for my grand total:


I guess I will need some pagination settings as well,

all help hugely appreciated!

1 Accepted Solution

Avatar

Correct answer by
Former Community Member
25 Replies

Avatar

Level 2

Ok i have figured out the calculations and I am getting exactly what i expect now.

I still have 1 remaining problem to (it is do with pagination settings)............I need to have each page displayed in the following way.

subform header

subform carryforward

subform sf1

subform footer

subform totalsf1

at the moment only the first page is correct, each following page only shows

                                        <----subform header is missing!

subform carryforward

subform sf1

subform footer

subform totalsf1

can someone help me with pagination settings, ive tried every combo i can think of but cant get the right order. form is attached below

Avatar

Level 2

solved, spent way too long on this and it was such a small thing!!!

I have put the carryforward subform inside the header subform, and set the header subform as the overflow leader. I also made the carryforward subform hidden if on the first page! Thanks for your help on this episode Paul.

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----