How do I reference reference a groupfooter total in an expression

[teztropo]

I'm sure there's an incredibly simple answer to this but its just got me stumped. I have rows of data within a group and in the group footer I have a total on one of those columns. What I want is a new data column in every row that will give me the % of this rows Value to the Group Footer Total. Like below:

Product Name Value %OfGroup
--------------------------------------------------
Product 1 40.00 20%
Product 1 70.00 35%
Product 1 90.00 45%

Group TOTAL: 200.00

So far what I've done to try and get %OfGroup is:
1) Named the Group Footer Total textbox as GroupTotalValue
2) enter in the %OfGroup the following expression: {Value/GroupTotalValue}

Nothing comes up in the %OfGroup column and instead I get an error message saying that:....Operator "/" cannot be applied to type "double" and "stimulsoft.report.component.stitext"

How can I get this going? Any help would be greatly appreciated!!!!

[Vital]

Please use following expression:

Code: Select all

{Value / Sum(Value) * 100}

Thank you.