calculation

[Sheik88]

I am trying to build an app to keep count of my items in store, I need a report page where i can view current stock in store. There will be new stock in every other week and stock to go out on a daily basis. Please advise

[HongTaiLang]

You can create a Tabular report DataPage http://howto.caspio.com/datapages/creating-datapages/creating-a-search-and-report-datapage/.

And then enable Totals & Aggregation: http://howto.caspio.com/datapages/creating-datapages/advanced-reporting/totals-aggregation.html

[NailDyanC]

Hi just to update this post.

Here are the updated links for creating and adding Totals and Aggregation:

https://howto.caspio.com/datapages/reports/creating-a-report-datapage/

https://howto.caspio.com/datapages/reports/advanced-reporting/totals-and-aggregations/

Totals & Aggregation are multi-record calculations that are available on the results pages of tabular Report DataPages. An example would be the total of a column that displays the Sales total for all records. In your part, you want to display it per week so you can create a view and filter it by date. For example, please see attached screenshot.

[cheonsa]

Hi @Sheik88,

 

Just to give an update, you can also check our video tutorial on how to create a Web Dashboard: 

 

Hope this helps.