This might seem as a very basic question, but I am trying to figure out a formula that will count the number of days that show an aging of 90-120 days old.
Solved! Go to Solution.
Are you trying to do this within a script or a chart? It´s often said that for performance reason it´s better to do this within the script and then you would create a new colum:
if(AgingDays > '90', ‘0',
if(AgingDays < '90', '1',
if(AgingDays < '120', '0'))) as AgingDaysCount
Then within your chart you can use Sum(AgingDaysCount)
I hope this helps.