Include Null into my Count

[pgalvezt2021]

Hello, I need to count only the days for Alfredo (Alfredo is selected) including the day 02-12-2021 (which is a null value)

The table should show 5 values
11-29-2021 Alfredo
11-30-2021 Alfredo
12-01-2021 Alfredo
02-12-2021 Alfredo (Here is the null value because in the original data, Alfredo did not enter any data that day)
03-12-2021 Alfredo

Its Possible?

I have created 1 Inline Script to simulate my data in excel.

Thanks !!

[pgalvezt2021]

Hello!!

any help ??

Thanks!

[tresesco]

Try this:

Count({1<Fecha={"=Len(Concat({1}Nombre))=0"}>} Fecha) + Count(Fecha)

However, I think there should be a better expression with single count(), something like:

Count({$+1<Fecha={"=Len(Concat({1}Nombre))=0"}>} Fecha)

Unfortunately not working, and couldn't invest more time today. 😞

[pgalvezt2021]

Hi,

Thank you for your reply,

I tried with master calender where the date of inline table is associate with the date  of the master calender too, but doen't work either.

[marcus_sommer]

NULL isn't a value and won't be stored in any way. Therefore it's not directly accessible with any functions or selectable. In many cases is the simplest solution to create appropriate records within the script.

In your case by counting continues dates you may bypass the challenge with something like:

max(Date) - min(Date) + 1

 - Marcus

[pgalvezt1]

I think, this is not possible to obtain,