Hello Mohamed.

I understand you are seeing different dates in your OLAP, right?

Functions are calculated before filters (Except normal agg like SUM, AVG, etc.)

To get functions "filter aware" you can use FILTER_TO_NULL.

https://help.celonis.cloud/help/display/CIBC/FILTER_TO_NULL

Example:

PU_SUM( TABLE , FILTER_TO_NULL( TABLE.COLUMN ) )

Thank you.

Daniel.

Thanks for the suggestion! I was able to sort it based on date thanks to FILTER_TO_NULL

However, since I am filtering it based on a certain column I have to apply it as a component filter

Although this works for now, I am getting a not below the OLAP table that informs me that apply a FILTER_TO_NULL within a FILTER is deprecated and that it will not receive support in the future

When I try to do the filter within the formula itself it goes back to displaying the null values while correctly sorting it based on date

Any suggestions on a strategy rework?