Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
ShowAll Questionssorted byDate Posted
Gab 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!