Sign in to Community
Sign in to view all badges
I have a trouble in breaking page based on a certain field which is sub total highlighted in yellow. and after last sub total, it is required to show Total of all sub total.
Please see my followings:
For this To-be, I have set up conditional breaks as below but it is not working as expected, " C-LCurrMonthAnount " is the sub total field)
It would be really appreciated if you can advise me how to achieve this requirement.
You don't need a conditional break for subform "Table" but its nested subform "Periods".
Just add this FormCalc script to create a page break for each except the last instance.
$.index lt Table._Periods.count - 1