Custom Template and Aggregate Field (sum)

ASP.NET Maker General Discussion (ASP.NET Maker)
1

I have a custom view (please don’t advise me to create a database view instead. I don’t have access to do so.) and I am trying to add sums to a field.
I have my page rendering properly except the sum in the footer Custom TemplateFooter.

The Custom View is named Live_Schedule.
The field name is SCHEDHRS. I have set Aggregate to Total in the field setup. In the Custom TemplateBody {{{SCHEDHRS}}} renders properly in each row.
In the custom template footer I have: {{{sum SCHEDHRS}}} but it does not render properly.

I get this instead:

#tpgs_Live_Schedule_SCHEDHRS

What am I doing wrong?

Thank You.

2

I was using {{{sum Field}}} where I should have just put {{{field}}} in the custom template footer. I guess when “Aggregate → Total” is selected in field setup, it will use the total value here.

I wish the help file was a little bit more clear. The way it is now can be misleading.
Help file shows:
{{{sum|avg|min|max|cnt field}}}

I think it should be:
{{{field}}} (sum|avg|min|max|cnt) will be calculated in custom template footer if Aggregate is defined.

3

The {{{sum|avg|min|max|cnt field}}} tags are for summary reports only. It is placed under “Summary reports support the following tags only:”.

4

Any solution to this , on how two some two different field on the same table and also for different table and put the total sum in another record, for multiplication , division , subtraction and some other mathematical function.

5

Use the Custom Field feature if you want to calculate based on field values and put the result to another field.