Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the format of your date field?
hi manish,
format of your date field:DD-MM-YYYY
Have you created a Master Calendar?
Also,
What is the meaning of till Previous Month? You want starting from your first date from database to previous month end?
Count(CmdbCi Names till Previous month)
Please clarify little more on above two questions, which will make easy to answer.
you are Correct,I want starting from my first date of database to previous month end.
I have created Master calendar
Can you provide sample data base or apps?
For Previous Month End
=SUM({<TransactionDate = {'<=$(=MonthEnd(AddMonths(Today(),-1)))'}>}Amount)
For Current Month
=SUM({<Month = {'$(=Month(Today()))'},Year = {'$(=Year(Today()))'}>}Amount)
You can change the field names according to your application...
Hi Manish
It is simpler
MonthStart(Today())-1
than
MonthEnd(AddMonths(Today(),-1))
results are the same
salutes
Hi Manish,
The Expression for Prevous Month is giving only Previous month Count.I need total count ( from starting date of my database )
Expression for Previous Month:
=Count({<[Fiscal Month]={'<=$(VarPrevFinMonth)'>}cmdbci_name) it is not Working.
Regards,
Harish
Hi,
Expression for previous Month End:
=Count({<[Fiscal Month]={"<=$(=VarPrevFinMonth)">}cmdbci_name)
Regards