Maximo Open Forum

I was wondering if it is possible to create an Asset Cost Report that shows each month's cost throughout an entire year.  

We have a YTD Asset Cost Report, but I was wondering if I could create a report that would show each month's cost, along with the YTD cost.

So the report would have 12 months with each month's cost underneath, along with the YTD cost.

Thank you

#Administration
#Assets
#EverythingMaximo
#Inventory
#Reporting

------------------------------
Danny Richardson
Maximo Administrator Manager
Technimark LLC
------------------------------

Hi Danny,

To me it seems possible.

I had some requiremnt not exaclty like this but I wanted to get the count of records created in each month of year.

So I created the below query, which returns the year in one comlumn, respective month one after the other in next column and count of records in that month which is created in third column.

Reference query: 

select to_char(Created Date,'YYYY') as year,
to_char(Created Date,'MM') as month,
count(*) as record_count
from asset where (Append you where condition if any)
group by to_char(Created Date,'YYYY'),to_char(Created Date,'MM')
order by year,month;

Now you can change the date field name and object name and you can also append the where clause if you have any and instead of count you can take the sum of the cost field in your object.

Thank you!

------------------------------
Tanishk Rathi
------------------------------

Thank you for the response.  I will have to look into this further.

------------------------------
Danny Richardson
Maximo Administrator Manager
Technimark LLC
------------------------------

Original Message:
Sent: 04-15-2024 22:43
From: Tanishk Rathi
Subject: How to create an Asset Cost Report that shows each month's cost throughout an entire year?

Hi Danny,

To me it seems possible.

I had some requiremnt not exaclty like this but I wanted to get the count of records created in each month of year.

So I created the below query, which returns the year in one comlumn, respective month one after the other in next column and count of records in that month which is created in third column.

Reference query: 

select to_char(Created Date,'YYYY') as year,
to_char(Created Date,'MM') as month,
count(*) as record_count
from asset where (Append you where condition if any)
group by to_char(Created Date,'YYYY'),to_char(Created Date,'MM')
order by year,month;

Now you can change the date field name and object name and you can also append the where clause if you have any and instead of count you can take the sum of the cost field in your object.

Thank you!

------------------------------
Tanishk Rathi
------------------------------