Set analysis problem

[munna1317]

hi QV,s

Can you plz Tell me this Expression in Set analysis

I have CMDBCI table.

Req:I want count of CmDBCInames for current month/Count(CmdbCi Names till Previous month)

Thxs in advance

harish

[munna1317]

hi,

PFA

Regards,

harish

[munna1317]

hi QV's ,

It is very urgent any suggestions plz reply

regards,

harish

[MK_QSL]

There is a problem in your cmdbci_Date field.. It is having multiple formats... First you need to make sure that cmdbci_Date field should be converted in a single date format...

Use below expression to do the same...

Alt(Date(Date#(cmdbci_Date,'DD-MM-YYYY')),Date(Date#(cmdbci_Date,'DD/MM/YYYY'))) as cmdbci_Date,

Now use below expression to get your expected result...

=COUNT({<cmdbci_Date = {'<=$(=MonthEnd(AddMonths(Today(),-1)))'}>}cmdbci_name)

Update : or if you want Data Upto Last Month End as per user selected cmdbci_Date, use below

=COUNT({<cmdbci_Date = {'<=$(=MonthEnd(AddMonths(Max(cmdbci_Date),-1)))'}>}cmdbci_name)