Last Page Number
-
- Posts: 20
- Joined: Tue Oct 10, 2017 12:44 pm
==> RE: Last Page Number
Almost forgot, I would appreciate anyone^s comments as to how this fix worked for you, or any suggestions how to improve above to make this more straight forward, may be a user function that does all the above in one step.____David
-
- Posts: 20
- Joined: Tue Oct 10, 2017 12:44 pm
===> RE: Last Page Number
I just found one problem with my approach. When total records divided by records per page result in integer, result will be one extra page. to fix this we change CountOne/Y+1 to CountOne/Y-0.001+1____David
-
- Posts: 20
- Joined: Tue Oct 10, 2017 12:44 pm
====> RE: Last Page Number
I thought of another situation when the above will not work acurately.__Here is the fix:__INT(CountOne/X+0.999)__Where X is the number of lines per-page.____This is how it works:__Total Records / Records per page + 0.999__then we take an integer value of the result.____David__