Skip to main content

I want to create a filter of an ELSE inside my condition.

 

The  ELSE 'Área Não Aderente'. Below script. I want to bring only the data from this ELSE, which would be the opposite of my condition below.

 

 

CASE WHEN

 

  ("EKKO"."BSART" LIKE 'Y%' OR "EKKO"."BSART" LIKE 'PE' OR ("EKKO"."BSART" LIKE 'Z%' AND "EKKO"."BSART" NOT IN ('ZCG','ZPM', 'ZCAT')))

  AND

  ("EKKO"."EKGRP" LIKE 'I%' OR "EKKO"."EKGRP" IN_LIKE ('%1I','%2I','%3I','%4I','%5I','%6I','%7I','%8I','%9I') OR "EKKO"."EKGRP" LIKE 'A%' OR "EKKO"."EKGRP" LIKE '01A')

   

 THEN -- Pedido por Área

 

  CASE WHEN

  

  PU_COUNT("EKKO", "EKPO"."MATNR", "EKPO"."MATNR" IN_LIKE ('%3001009%', '%3000926%', '%3000927%'))>0 -- Cadastro de Material

  OR

  (PU_COUNT("EKKO", "EKPO"."MATKL", "EKPO"."MATKL" IN ('GI001710A'))>0 -- Grupo de Mercadoria

   AND

  "EKKO"."EKGRP" IN ('I09')) -- Grupo de Comprador

  OR

  "EKKO"."EKGRP" IN ('I38', 'I13','I12') -- Grupo de Comprador

  OR

  "EKKO"."Z_BSGRU" IN ('INT')

  AND

  "PO_LFB1"."FDGRV" IN ('FPREL') -- Contratos Intercompany

  THEN 'Área Aderente'

   ELSE 'Área Não Aderente'

  END

 

 ELSE 'Supply'

 

I need to filter only this condition, which would be the opposite of my condition above (ELSE)

 

Thanks.

Hi @douglas.henri,

 

If you are using 'Saved Formulas' (Studio Analysis) or 'KPIs' (Studio Knowledge Model), it is very easy to nest multiple statements.

 

In this case, your formula will become something like:

 

FILTER KPI("your kpi name here") = 'Área Não Aderente';

 

If it should be the opposite, use != instead of =.

 

Hopefully this helps.

 

Kind regards,

Jan-peter


Hi @douglas.henri,

 

If you are using 'Saved Formulas' (Studio Analysis) or 'KPIs' (Studio Knowledge Model), it is very easy to nest multiple statements.

 

In this case, your formula will become something like:

 

FILTER KPI("your kpi name here") = 'Área Não Aderente';

 

If it should be the opposite, use != instead of =.

 

Hopefully this helps.

 

Kind regards,

Jan-peter

Many thanks for your help as always Jan-Peter !


Reply