How to count the empty values from date Info object.

[former_member184624]

Hi BW Experts,

I am working on creating the reports.

In my requirement, there is a info object Capitalization date which contains date values and "#" values.

I want to count the records where capitalization date is # (Empty).

I have done the count for the records having capitalization date. But i dont know, how to count the records which is empty.

Please suggest on this requirement.

Thanks.

[yasemin_kilinc · Accepted solution]

Hi Jalina,

You can find the number of records in a calculated key figure. Then you can create a selection where you add this calculated key figure and the capitalization date. Then restrict the capitalization date with #.

Hope it gives an idea.

Yasemin...

[former_member184624 · Accepted solution]

Thank you. It is working now.

[yasemin_kilinc · Accepted solution]

I am glad you have done it Jalina