Count Function

chengchenggan
Occasional Contributor

Count Function

Hi,

 

How could I count days by 1) weekday type and 2) Actual data or not. Ideal result would show X day for "Weekend" for Actual data, Y day for "Holiday" for Forecast data.. etc. 

  • Index is a "Day" list from 1 to 31.
  • Column "Weekday" and "Actual data" are manual input. 
  • "Value" is a supporting column. Feel free to change the format or add/delete. 

 

chengchenggan_0-1611265994546.png

 

Ideal result:

chengchenggan_1-1611266100263.png

 

Thanks,

Jane

1 ACCEPTED SOLUTION

Accepted Solutions
jasonblinn
Master Anaplanner/Community Boss

Re: Count Function

@chengchenggan 

I think there are a couple of ways to go about this. The most simple would likely be to stage it out the way that you have it, but also add a line item for the forecast. Both of these are based on the "Actual" line item.

jasonblinn_0-1611279382011.png

 

From there, you can just create a new module that has the list that contains "Weekday, Weekend, and Holiday"  as a dimension, and have a line item for Actual Day Count, and another for Forecast Day Count.

 

jasonblinn_2-1611279601420.png

For the formula, you want to pull the Forecast or the Actual line item from the first line item and sum it across the weekday line item.

My formula here is: Monthly Module By Day.Forecast[SUM: Monthly Module By Day.Weekday]

 

Hope this helps!
Jason

 

 

View solution in original post

2 REPLIES 2
jasonblinn
Master Anaplanner/Community Boss

Re: Count Function

@chengchenggan 

I think there are a couple of ways to go about this. The most simple would likely be to stage it out the way that you have it, but also add a line item for the forecast. Both of these are based on the "Actual" line item.

jasonblinn_0-1611279382011.png

 

From there, you can just create a new module that has the list that contains "Weekday, Weekend, and Holiday"  as a dimension, and have a line item for Actual Day Count, and another for Forecast Day Count.

 

jasonblinn_2-1611279601420.png

For the formula, you want to pull the Forecast or the Actual line item from the first line item and sum it across the weekday line item.

My formula here is: Monthly Module By Day.Forecast[SUM: Monthly Module By Day.Weekday]

 

Hope this helps!
Jason

 

 

View solution in original post

chengchenggan
Occasional Contributor

Re: Count Function

Thank you! that's very smart to add a new supporting line item "forecast".