PU_COUNT_DISTINCT ("_CEL_OTT_CASE_TABLE_NWF_DD",FILTER_TO_NULL("_CEL_MERGED_ACTIVITIES"."ACTIVITY"),
"_CEL_MERGED_ACTIVITIES"."ACTIVITY" LIKE 'NWF: Due % & Release'
AND
"_CEL_MERGED_ACTIVITIES"."TEAM_LEADER" = 'Robben Ramatlo'
)
Question
Hi all, is it possible to use a global statement in a PU function. I want to keep the filters global in the PU function.
+6
+6PU functions do not take into account filters by default, the result of your PU funtion, in your case the PU_COUNT_DISTINCT, will be influenced by the filters because you are using FILTER_TO_NULL. If what you want is that your PU does not take them into account I suggest removing the FILTER_TO_NULL. Does that answer your question? otherwise, with more information about your specific query I might be able to support further.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.