Implementing Dynamic Pagination: Variable Calculation for Dropdown Values


I’ve established two variables to facilitate pagination. The first variable, named ‘PageSize,’ is a custom parameter, and I’ve assigned it a value of 20. The second variable is a query parameter called ‘TotalRows.’ To obtain the total number of rows in my dataset, I’m utilizing an infinity data source and getting my count from an API.

Now, my objective is to create a third variable, which will be a dropdown list of numbers. These numbers will be derived from the calculation “TotalRows/PageSize.”

I’m seeking guidance on how to perform this division between two variables, or if there’s an alternative approach that you could suggest.