Pre Calculated Column

doghouse · Post by **doghouse** » Wed May 21, 2008 7:25 pm

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.

Post by **Vital** » Thu May 22, 2008 12:29 am

Hello,

Please try following code:

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

Thank you.

doghouse · Post by **doghouse** » Thu May 22, 2008 1:33 am

Did not work
Tried decimal and string , no luck.

How do i copy and paste the error messages?

doghouse · Post by **doghouse** » Thu May 22, 2008 1:48 am

Sorry for the accidental PM Vital

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

Post by **Edward** » Thu May 22, 2008 7:16 am

Please change the expression in TotalArea column as follows:

Code: Select all

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

Thank you.

doghouse · Post by **doghouse** » Thu May 22, 2008 4:55 pm

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"

Post by **Edward** » Thu May 22, 2008 5:05 pm

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

Thank you.

doghouse · Post by **doghouse** » Thu May 22, 2008 8:28 pm

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

Post by **Edward** » Fri May 23, 2008 12:01 pm

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

Code: Select all

Totals.Sum(CombinedParts, CombinedParts.AreaQtyTotal)

Thank you.

doghouse · Post by **doghouse** » Sun May 25, 2008 7:20 pm

Hi Edward, thanks for that, will update soon.