If you have an OLAP table and you are trying to sort from lowest to highest based on a numerical column how do you remove the columns that appear as null values?

Question

I have an OLAP table that is sorted by # of days (in screenshot named first). But I am trying to produced the same table, but in the format represented in the screenshot labelled as second.

Essentially I want the tables sorted from lowest to highest # of days and also removed the NULL (-) values associated with each client.

I have rewritten the queries for each column to support PU functions and was planning to use a DOMAIN_TABLE for this purpose, but when I use the DOMAIN_TABLE within the component filter to remove nulls when ISNULL(...)=1 it still remains the same as first

vincent.freem · Answer

Hi Mohamed,Removing the null values for each column should be possible using a component filter statement but making ISNULL =0.If this does not work feel free to reply with the column formulas but it should work in the filter like:FILTER ISNULL(# of days formula)=0;FILTER ISNULL(value formula)=0;FILTER ISNULL(transaction field)=0;

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN