topic Re: SUM field if respect a condition? in App Development

SUM field if respect a condition?

Wed, 18 Nov 2015 09:37:47 GMT

Hi ,

I need to create an expression that is the sum of WORK TIME of the machine and AVAIBLE TIME of the MACHINE.

The "Available Time " is the sum of Duration without the row with "code causal" =300

My expression is :

Available_Time = if( Code Causal<>300,Sum(Time),0)

My expression is :

Work_Time = if( Code Causal=210,Sum(Time),0)

But for the Work time the expression doesn't work, no result.

After i would use these expressions to create one KPI, that is the percert of Work Time / Available_Time.

Could you help me?

Thanks a lot

Fede

oknotsen — Wed, 18 Nov 2015 09:52:22 GMT

I suggest using something we call "Set Analysis" instead of IF statements.

For Work_Time:

sum({< [Code Casual] = {210} > } Time)

For Available_Time:

sum({< [Code Casual] -= {300} > } Time)

sunny_talwar — Wed, 18 Nov 2015 09:53:03 GMT

Try it with set analysis instead:

Available_Time = Sum({<Code Causal ={'*'} - {300}>} Time)

Work_Time = Sum({<Code Causal ={200}>} Time)

Wed, 18 Nov 2015 10:26:11 GMT

Thanks Sunny!!!

It works fine!!!

oknotsen — Wed, 18 Nov 2015 10:29:54 GMT

Even with the space in the name "Code Causal"? That is a surprise to me.

sunny_talwar — Wed, 18 Nov 2015 10:49:22 GMT

Hahahaha I think he must have added it in his code