I have Ast Identifier, Add Record, Ast Count, Active Indicator,
I have other two filed Active time, Which gives when assets became active and Replaces Time, Which give me when assets change status
I have to find out How many asts added on that Individual month,and I saw Active Indicator = Y, N ,T
From this I need to find out How many asts active in the beginning of that month,
How many in that end of the month ( I mean N or T)
mk19 
(BOB member since 2009-07-20)
Hi mk19,
I don’t want to be rude but I don’t think that you’ve explained what you’re trying to do very well here - but that doesn’t mean we can’t help!
What I understand from your post is that you want a count of [Ast Identifier] where [Active Indicator] is either N or T since the beginning of the month? Am I right in thinking that [Active Time] gives you a date & time?
If it does - or you have another form of date applicable to [Ast Identifier] then you need to create a test of somekind on that date in your calculation to determine if it’s in the current month. Working with [Active Time] as your (presumed) date field:
=Count [Ast Identifier] where ([Active Indicator] inlist (“N”;“T”); monthnumberofyear([Active Time])=monthnumberofyear(CurrentDate());year([Active Time])=year(Currentdate()))
Or - you could roll up the tests into one variable to give you a Y or N against an Identifiier.
test1
= if ([Active Identifier] inlist (“N”;T");“Y”;“N”)
test2
=if(monthnumberofyear([Active Time])=monthnumberofyear(CurrentDate());“Y”;“N”)
test3
=if(year([Active Time])=year(Currentdate()));“Y”;“N”)
Overall Test
= if([test1]=“Y” and [test2]=“Y” and [test3]=“Y”;“Y”;“N”)
Then
=count([Active Identifier]) where ([Overall Test]=“Y”)
SteveD 
(BOB member since 2009-11-02)
Hello Steve,
Sorry, I was not that clear –
I am looking for those assets Which is active in month of Dec, but not in the month of January( Those assets status change Y To N )
does this help?
Thanks!
mk19 (BOB member since 2009-07-20)
Don’t apologise! It was just a little difficult to understand what you were after. 
So is it not just:
=count([assests]) where ([status] = “Y”) and monthnumberofyear([date field])=12; distinct)
?
I take it that an assett has multiple dates in your report, so at one point in time has the status of Y, and at another N. If you have multiple rows of data for an assett in a month - in this case, december - you may need to count;distinct your assetts. View the helpfile on count for more info. I have to get off now, it’s the weekend!
SteveD (BOB member since 2009-11-02)
Hello,
Thanks for your reply – the count is working fine.
Now got new requirement for monthly comparison – Ast those were Active Last month and Inactive this month; need to get the listing.
The outcome would be like this:(Jan-Feb comparison)
ID PreviousMonthIndicator CurrentMonthIndicator Change Date
121 Y N 2/1/10
I’m thinking this is possible only by custom SQL, as the available table is TYPE II dimension.
Awaiting reply… 
mk19 
(BOB member since 2009-07-20)