function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Gab SilvermotionGab Silvermotion 

Stackable/cumulative Date range formula for reporting

Hello!

 

i'm trying to find a way to report on our sales rep activities, and i'd like to use a stackable date range formula.   To be precise, i'dl like to separate activities into 3 dates range, 0-7 days, 0-30 days, and 0-90 days. 

 

using this formula, i am able to obtain a date range, but it's not stackablecumulative, meaning that the 0-7 days value won't be included in the 0-30 and 0-90 days periods

 

IF(AND(FLOOR(TODAY()-DATEVALUE(CreatedDate))>= 0,FLOOR(TODAY()-DATEVALUE(CreatedDate))<=7), "00-07 Days", 
IF(AND(FLOOR(TODAY()-DATEVALUE(CreatedDate))>= 0,FLOOR(TODAY()-DATEVALUE(CreatedDate))<=30), "07-30 Days", 
IF(AND(FLOOR(TODAY()-DATEVALUE(CreatedDate))>= 0,FLOOR(TODAY()-DATEVALUE(CreatedDate))<=90), "30-90 Days", 
"Older than 90 days" 
)))

 

 

for exemple, i am getting this 

 

 

0-7 days : 5

7-30 days : 5

30-90 days : 5

total : 15

 

and i'd like to get this

 

0-7 days : 5

7-30 days : 10

30-90 days : 15

total : 15

 

in other words, the 0-90 days includes stuff from the 0-30 and 0-7 days. 

the 0-30 days includes stuff from the 0-7 days

 

how can i do that?

 

thanks!