RunningCount does not work with sections

building reports desktopintelligence
1

I have a running count:

Machine Count Running Count

21 1 1
21 1 2
23 3 5
24 1 6
24 2 7
24 3 10

When I now section by machine, I get this

21

Count Running Count

21 1 1
21 1 2

Count Running Count

23 3 5

As can be seen, the running count does not reset at the start of each section. Why not?

Running Count= runningcount(OID)

(Where OID is unique ID for each row)

fghs_1987 :uk: (BOB member since 2008-01-02)

2

Hi Joseph

I think you need to specify the section object (eg machine) in the parameters to RunningCount.

See the section on RunningCount in here for the full syntax. This guide is for WebI, but the syntax maybe similar for Deski.

Cheers, Sandi

SandiR :uk: (BOB member since 2004-12-20)

3

I tried this:

runningCount(OID) In (Machine)

Still no change.

Is this a bug?

fghs_1987 :uk: (BOB member since 2008-01-02)

4

Hi again Joseph

Can you try …

 RunningCount(<OID>;<Machine>)

This seemed to work for me

SandiR :uk: (BOB member since 2004-12-20)

5

Sandi that worked great!! Many thanks.

fghs_1987 :uk: (BOB member since 2008-01-02)