Total on Expense Report

[robertf]

How do I total up the Amount of all expense items on an Expense Report?
I would like to have it at the bottom of the Items, but adding it to the top area would work.
I see totalCurrency, but doesn't seem to be used.

Thanks

[tanya]

Hello
You can have total row with Grid Report.

[skylabz0rz]

Is there a tutorial on this? I am building a similar expense report but have no idea what any of the function codes means or how to program this.

[tanya]

Video tutorials, related to report

https://www.espocrm.com/video/reports-and-analytics/

https://www.espocrm.com/video/export-reports-to-excel-format/

[robertf]

Is there a way to use the formula language to total up the expenseitems expenseAmounts into a new total field on the expenseReport entity?

Also, what is totalCurrency used for in the expenseReport entity?

[spacemnspiff]

I have the same question

[tanya]

not for now. You can do it with hooks, for example https://www.espocrm.com/documentatio...lopment/hooks/ , https://www.espocrm.com/documentation/development/orm/