Count of Days

[mhmmd_srf]

Hi all,

I have one requirement like if I select one date from it will show me the distinct count of Dates till date. Like below as an example:

If I select 7/5/2017 , then it should show 3 as Count of Days. But if I select any date it is always showing 1.

I am attaching my sample App.

Please help.

Thanks,

Sarif

[sunny_talwar]

If 7/5/2017 is selected, then you want to see 3, otherwise you want to see 1?

[mhmmd_srf]

Yes. I will select a date and it should show count of distinct date from First Date of the Month till that Date.

[sunny_talwar · Accepted solution]

May be this

=NetWorkDays(MonthStart(Max(CstDate)), Max(CstDate))

[Kushal_Chawda]

try below expression in text object

=Date-min({1}Date)+1

[tresesco]

May be:

=Max(CstDate)-MonthStart(Max(CstDate))

[Kushal_Chawda]

or try this

=count( {<CstDate={"=sum({<CstDate={'>=$(=min({1}CstDate))<=$(=max(CstDate))'}>}OrdersReceivedUnits)>0"}>} distinct CstDate)