Choice criteria in set analysis

[pirotfab]

Hello,

You find the table with the infos

I want to get the time "OK" and the time "KO" for the dimension Test

The conditions: if T YPE = ESSAI then "KO3, if CODE = T100 then KO otherwise OK


For that I put these formulas =

Expression OK : sum({<TYPE-={'ESSAI'},CODE-={'T100'}>} TPS)

Expression KO : sum({<TYPE={'ESSAI'},CODE={'T100'}>} TPS)

The result

My wish is to obtain 24h on the sum of the two expressions.


Is it possible to pass only with the set analysis to realize this table or should I use one if nested moreover?



Thanks for your feedback

Cdlt

[sunny_talwar]

May be try this

If(Len(Trim(POSTE)) > 0, Sum(TOTAL <CODE> {$-(<typeln={'POSTEVT'},ofessai={'ESSAI'}>+<%code_type_evt={'FERME','MAP','T402','T403','T401','T405'}>)} duree))

[pirotfab]

it's not ok.

The problem is the expression Tps ouv (s).

that's what makes me two POSTE line

[sunny_talwar]

But that is the expression I am asking you to change with this one

If(Len(Trim(POSTE)) > 0, Sum(TOTAL <CODE> {$-(<typeln={'POSTEVT'},ofessai={'ESSAI'}>+<%code_type_evt={'FERME','MAP','T402','T403','T401','T405'}>)} duree))

[pirotfab]

thanks

It's ok

but if I add a dimension here is the result

[sunny_talwar]

Well, unless I know or see the whole thing... I won't be able to give you an expression which will work in all cases... the expression is not straight forward because of the way your data is...

[pirotfab]

ok ,

thank you for you help

i advance very well with you

thanks sunny

[sunny_talwar]

No problem at all