Show values in graph IF value of relating value = X

[#1]

Hello,

Ive got a relatively simple question. I want to plot a certain interval:

key         interval          unit

1-            800                  Hours

1-           1000                Cycles

2-          ETC.

2-   

So In my expression definition I say: =interval.

But this way it sums up 1000 and 800 if I select for key 1.

I only want to =interval where unit is hours. How do i formulate this simple expression?

[sushil353 · Accepted solution]

Hi,

Try:

=Sum({<unit = {'Hours'}>}interval)

HTH

Sushil

[MayilVahanan]

Hi

Try like this

=Sum({<unit = {'Hours'}>}interval)

[#4]

Works, thanks!