Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the example below I would like to use the rangesum function to sum the total for the Inbound column for every 7 records. Right now it is just a running total against the whole strait table. So I would like to calculated a sum for the Inbound column for rows 1-7, then 8-14, etc... Any ideas? Thanks.
you should have a look at rangesum(above(myfield,1,7)) something like that
you should have a look at rangesum(above(myfield,1,7)) something like that
That should work, but how to do you get it to repeat every 7 records? Thanks.