Forum Discussion
Calculating total per quarter for specified age
I'm trying to understand the easiest way to calculate the total # of assets with a specified age at the end of each quarter. Particularly, I want to know: count of assets that are 365 days old o...
Greg_Deckler
Community Champion
Community Championking98027 So your Asset's Age column denotes the current age as of, for example "today", is that correct? If that is the case, then you could use the end of the quarter date and the asset's created on date to do a calculation of the asset age at the end of the quarter. Are your quarters calendar based or fiscal?
Greg_Deckler That is correct. The asset age would be based off today's date. Quarters are calendar based. Unclear about how to go forth.