summary values on group level.

[mrzaxy]

hello guys,

I'm using iRep 4.0.0 and I have a simple report with one group. I have values on group (VALUE column)  and I want to calculated field ( % column) on proup level but I need values from the summary (100) for this.

Like this:

NAME                    VALUE           %

Description1         25                 25

Description2         25                 25

Description3         50                 50

 

Total                     100

 

 

Is it possible to create?

 

help me!

thank you!

[kolaitis]

try this....

Assign variable TOTAL_VALUE with appropriate expression

Assign variable VALUE                  -""-       -""-                -""-                   Reset Type:  Group    (your GroupName).   

Drag  variable VALUE on  (your GroupName)   eval.Time : Group,  eval.Group : your GroupName

Create text field  on  (your GroupName)  with expression :

new Double(($V{VALUE}.doubleValue() / $V{TOTAL_VALUE}.doubleValue())*100)

eval.Time : Auto.

I hope it will works.

[mcclellc]

Thanks - you saved me LOTS of frustration since the standard documentation doesn't get into these very common types of calculated fields. (I am getting the difference between two summary values and modifying your syntax above worked immediately.)