Expression...

[#1]

Hi all,

I am having a table with 2 dimensions execution date and status and I wan count of only those materials which are present in all these execution dates.

[PrashantSangle]

Hi,

Can you explain little bit more.

Like Status is always present even if your execution date is not present?

If yes,

Then try like this,

count(status={"=not isnull(execution_Date)"}materials)

It is better if you share sample data.

Regards

[#3]

please find attached sample data.

[PrashantSangle]

Hi,

I have checked your sample data.

How you calculating status as you mention in your question?

I did not find any materials with our execution date?

Regards,

[MK_QSL]

Count(Distinct Material)

[SunilChauhan]

in script itself

you could use if(len(Material)>0,Material,'Blank')

and in formula

Count(Distinct If(Material<>'Blank',Material))

and dimesion you could take status and executiondate

hope this helps