How to 'count' by month

[Rushhour]

Hi

I am doing a domain registry list, it will shows all the expired domains.

My expired dates are categorise by months using 'sub summary'.

I wish to count how many domains are there in this month (it will be show at the bottom to inform the user the number of domains expiring this month). Only this month number will be shown but not every month.

For my field I was thinking something like

exact(expired date; month(//)

count(expired date)

Can someone help me with this..?

Thanks a lot

Kelvin

[aaa]

Hi, Roshhour!

Creat one calculation boolean field:

Expaired_Current_Month=Case(Month(expired date)=Month(Today),1,0)

Then your Count_Field=summary total of Expaired_Current_Month

[Rushhour]

Hi aaa

So i will need 2 fields right.

Apologise.. how to create a calculation boolean field.. i couldn't find it.. haha..

Thanks a lot..

Kelvin

[Raybaudi]

Don't worry...

you haven't to create a boolean field !

the result of that calc is boolean as it may be 1 or 0.

[Rushhour]

Hi aaa and raybaudi

Thanks yeah, you guys are good!

btw Month(Today) dun works, i change it to Month(Get(CurrentDate)).

Cheers,

Kelvin

[Rushhour]

Hi

hm.. I am trying to get the number of my expired domains out of all domains.

I created 2 fields, 'expired domain calculation' and 'expired domain'

expired domain calculation - Date Expiry ≤ Get(CurrentDate)

expired domain - count ( expired domain calculation)

can't get it working.. i think im doing it the wrong way. Can someone helps..?

Thanks a lot

Kelvin

[aaa]

Hi, Roshhour!

Change "expaired domain" field to Summary as Total of "expired domain calculation".