Register

count wrt day timescale

tejaswini
Contributor

count wrt day timescale

Hello , 

 

I/p screen 

Products start date End Date
A11/3/20205/3/2020
A21/3/20208/5/2020

 

O/p Screen should contain the product count and it should look like

 1-Mar2-Mar3-Mar4-Mar
No of Products2221

Can we able to do this in anaplan?(As the output screen in Day time scale)

 

Thanks

Tejaswini

2 REPLIES 2
Ingilavicus
Certified Master Anaplanner

Re: count wrt day timescale

Hi @tejaswini ,

 

The first thing that comes to mind is that you should make an additional module with Products and time in dimensions. 

 

Then you just see if the product is active within a given period: IF date >= Start Date AND date <= End Date THEN 1 ELSE 0

 

If you have a top-level for the product you should see the # of products right away as a summary of that 1/0 condition. 

 

Hope this helps, Andris

alexpavel
Certified Master Anaplanner

Re: count wrt day timescale

@tejaswini  you will need an intermediary module Products X Day Time scale where per every day create a formula to verify if a Product is valid between Start and End Date. 

At Total Products you will see the correct number of valid products per every day. 

 

alexpavel_1-1618554918905.png

 

Hope it helps

Alex