Calculation, Positive Value expected (what did I miss?)

[Anonymous]

Hi,

I get a negative value, where I would expect a postive value..

Where did I go wrong?

Running (Seconds) = 
datediff( maxx
( filter ( Waste ,
[Indeks] = EARLIER ( [Indeks]) +1 ) ,
[Waste Start]) ,
[Waste Stop] ,
second
)

[Anonymous · Accepted solution]

Ok, maybe no pretty, bud did solve the issue..

Running (Seconds) = 
"-1" *
datediff( maxx
( filter ( Waste ,
[Indeks] = EARLIER ( [Indeks]) +1 ) ,
[Waste Start]) ,
[Waste Stop] ,
second
)