Show rows only if a value is "null"

[fgirardin]

Hello all,

I'm trying to modify one of my document.

The main view looks like this:

I separated the view into 2 specific tables (one for buying price, the other for selling price) for ease of use (and also to avoid some null values if the .

I use the following expression to separate PA from PV

Count({$<FIELD={"PA"}>}FIELD)    or    Count({$<FIELD={"PV"}>}FIELD)

My user needs to be able to quickly check the current prices for most of our articles. The only way I can do this is to show ONLY the rows that have a "null" value in "End Date" (wich indicate that it is the current price)...

In this example, I'd like to see only the third row (left table) and the fourth and fifth (right table)

Is there a way to show only the null value in those 2 tables ? (note that I cannot modify the script since I need all dates for other pages)

Let me know if I'm not clear.
Thank you for your help

[fgirardin]

Hi

Where should I use this ?
If I try to use as a dimension, I got "Error in expression, Garbage after '$' "

Thank you

[fgirardin]

I used the calculated dimension for all of them in my tables and I think it works:

If I don't select a specific article, I get only the "null" dates !

Thank you a lot Digvijay !!

[Digvijay_Singh]

Glad it worked for you, When you select any article, it may have associated with values with not null dates so it tries to find 'else' of the if condition we added, as  we don't have else, it might be trying to select null Cle' principles dimension.

As of now I am not finding what to put in else condition based on my current understanding of the data.