Developer

[elzaiem]

I am building an invoicing system. I need to design a datapage that shows total sales, total sales discount and finally the net sales. All the data is in one table. I want to get the totals without listing the records.

Sales:- 10,000

Discount :- 1,000

Net Sale:- 9,000

No of Invoices:- 25

Thanks

[Alison]

Hi @elzaiem,

You can make the calculations in the Formula field in the table and select only these formula fields to be shown on the datapage.

[SinJunYoung]

On 9/9/2020 at 12:54 PM, elzaiem said:

I am building an invoicing system. I need to design a datapage that shows total sales, total sales discount and finally the net sales. All the data is in one table. I want to get the totals without listing the records.

Sales:- 10,000

Discount :- 1,000

Net Sale:- 9,000

No of Invoices:- 25

Thanks

Can you give an example workflow? It would be nice if there's screenshots, pictures and diagram of sample workflow that you can send here so we can try to see how we will do it within DataPages display. You can use different functions to achieve that

For now, let this link be your guide:

https://howto.caspio.com/function-reference/

https://howto.caspio.com/datapages/datapage-components/calculated-values/

https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

 

Hope this helps