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
hi,
It is not working .It results 0 value
Hi,
check in text box what is your variable VarPrevFinMonth evaluating?
Sometime it convert your date to number
also check Your Fiscal Month format in list box
Regards
Hi Max,
I have checked VarPrevFinMonth is evaluating in text box .Month Format is MMM(Jan)
and Fiscal month format also same MMM(Jan)
Hi,
If possible post your sample apps?
One more thing if you want last month then add Year Field also in your set analysis.
Like,
Count({<[Fiscal Month]={"<=$(=VarPrevFinMonth)",[Fiscal Year]={"<=$(=VarYear)">}cmdbci_name)
Regards
Hi
Instead of using month field, try with date field in set analysis for calculating from start date to end of previous month.
hi ,
Can u please tell me how to get data till Previous Month end.
do you have any example Expressions or Conditions?
Regards,
Harish
Hi
I am using this Date field,but still i m getting 0 value
=Count({<CIDate={">=$(=DATE(MakeDate(2007,01,01),'DD-MM-YYYY')))<=$(=Date(Max(AddMonths(CIDate,-1)),'DD-MM-YYYY'))"} >}cmdbci_name)
Hi
Expression looks correct..
Did u please confirm that CIDate is also "DD-MM-YYYY" format or its in "MM-DD-YYYY" format?
hi,
CIDate format is 'DD-MM-YYYY'
Hi
Can you provide a sample data in excel file ?