I am trying to produce a report that is 101 with a spreadsheet but can’t figure out how to do it with Caspio.
Very simplified so I can explain my difficulty. I have two tables <Income> and <Cost>. Each table contain the following fields:- ID; Project#; and Amount.
My desired report something like this
Project# ~ Income_Amount ~ Cost_Amount
1$200
1$250
1$150
1$250
Total Project$450$400Profit $50
I tried to use a View to get the <Income> & <Cost> by project , However, I wound up hundreds of records - seemed to combine every <Income> with every<Cost>. And the report was meaningless.
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
Colnocode
I am trying to produce a report that is 101 with a spreadsheet but can’t figure out how to do it with Caspio.
Very simplified so I can explain my difficulty. I have two tables <Income> and <Cost>. Each table contain the following fields:- ID; Project#; and Amount.
My desired report something like this
Project# ~ Income_Amount ~ Cost_Amount
1 $200
1 $250
1 $150
1 $250
Total Project $450 $400 Profit $50
I tried to use a View to get the <Income> & <Cost> by project , However, I wound up hundreds of records - seemed to combine every <Income> with every<Cost>. And the report was meaningless.
Simple task but how?
Link to comment
Share on other sites
4 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.