Sim before Detail Band

My Report has a column "CASH".

I want to calculate the Percentage based on Sum.

Data:

ROWID:1, CASH: 10000

ROWID:2, CASH: 20000

ROWID:3, CASH: 30000

When I create a simple variable to calculate the sum the sum is only properly calculated at the end of the detail band. I.e. the Sum is first 10000, then 30000 (10+20), and then 60k.

 

How do I have the variable field be calculated before the detail band?

dunham's picture
403
Joined: Oct 18 2013 - 6:57am
Last seen: 1 year 1 month ago

1 Answer:

sanbez's picture
6400
Joined: Jan 11 2011 - 2:06am
Last seen: 2 years 8 months ago
Feedback
randomness