Creating reports and dashboards | Stimulsoft community forum

Hi there
Another quick question, Im wanting to to create a precalculated column as follows to give me the total area for different types of materials:

CombinedParts.Area = CombinedParts.Length * CombinedParts.Width (This I have precalculated and is working.)

What i want to do now is to calculate the total area of all parts according to their material type.
So I try to make another precalculated column as follows:

CombinedParts.AreaTotal = sum(CombinedParts,CombinedParts.Area)

This will not work for me, Im not sure if its syntax or something else. I need the area total so I can multiply it by CombinedParts.SqrFtCost to get a cost in $.

When I used CombinedParts as a data band and group header of CombinedParts.Material i can then calculate the are total.
{Sum(GroupHeader1,CombinedParts.Area)}. Unfortunately i cannot use this figure any further.

Hello,

Please try following code:

CombinedParts.AreaTotal = Totals.Sum(CombinedParts,CombinedParts.Area)

Thank you.

Did not work
Tried decimal and string , no luck.

How do i copy and paste the error messages?

Sorry for the accidental PM Vital

Here is a link to the report in question Cost Estimate Report

Please change the expression in TotalArea column as follows:
Thank you.

Edward wrote:Please change the expression in TotalArea column as follows:

Code: Select all

Totals.Sum(CombinedParts, Me, CombinedParts.Area)

Thank you.

Hi Edward
Thanks for the reply, there was no errors but I do not get the value i need, ie the value it calculates is "zero"

Please send the data for your report to support[at]stimulsoft.com as well, we'll try to check it once more.

Thank you.

Hi Edward, an email has been sent!
Thanks :biggrin:

This declaration of 'TotalsArea' calculation column will work in the prerelease build starting from 12th of May.
Thank you.

Hi Edward, thanks for that, will update soon.