Skip to main content

Hi all, 

 

I created an attribute (“MARC”.”cond_mbew_compl_vprsv”) as a boolean with the following formular:

CASE WHEN(
  ( "MARC"."BESKZ" = 'E' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'S' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."STPRS")) = 0 ))
    OR
  ("MARC"."BESKZ" = 'F' AND ( PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VPRSV")) NOT IN ( 'V' ) OR PU_FIRST("MARC",FILTER_TO_NULL ("MBEW"."VERPR")) = 0)))
THEN 1 ELSE 0 END
 

Now I want filter like followed: FILTER "MARC"."cond_mbew_compl_vprsv" = 1

 

This does not work and I got the following error message: Calculated attribute l"MARC"."COND_MBEW_COMPL_VPRSV"] cannot be used inside a FILTER because it takes filters into account.

 

Can you help me what I should change?

 

Thank you.

 

Regards

Hi Julia,

 

In your calculated attribute, remove the FILTER_TO_NULL function. It’s a function that’s meant to be used sporadically in KPIs (in most cases) so that specific filters can be applied appropriately. You can read the doc for more details 🙂

Reply


Community Code of Conduct