I want thank those that have helped me so far, but I have run into another roadblock. On my reports page I have nine columns. The first aggrigate sums each of the columns. This works as designed. The second aggrigate should apply a calculation to each of the columns (CalorieGoal - SUM, ProteinGoal - SUM, CarbGoal - SUM, etc.) across the nine columns. The last time I asked for help, the solution was to apply the calculation in a new aggrigate and the in the footer move the aggrigate to the second aggrigate and hide the 3rd, 4th aggrigate in the header. I applied this code and it worked, as you can see in the screen shot below.
Then I ran into the BIG PROBLEM. Caspio only supports five aggrigates.
Does anyone know of a solution or a work around? I really need one.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Lynda
I want thank those that have helped me so far, but I have run into another roadblock. On my reports page I have nine columns. The first aggrigate sums each of the columns. This works as designed. The second aggrigate should apply a calculation to each of the columns (CalorieGoal - SUM, ProteinGoal - SUM, CarbGoal - SUM, etc.) across the nine columns. The last time I asked for help, the solution was to apply the calculation in a new aggrigate and the in the footer move the aggrigate to the second aggrigate and hide the 3rd, 4th aggrigate in the header. I applied this code and it worked, as you can see in the screen shot below.
Then I ran into the BIG PROBLEM. Caspio only supports five aggrigates.
Does anyone know of a solution or a work around? I really need one.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.