6 Replies Latest reply: Jun 14, 2018 2:52 AM by Ruben Marin

# Set Analysis divide monthly value into daily value

I am having trouble creating a chart that will track percent to plan by day.  The plan is loaded in a script with fiscal day equal to the last fiscal day of the month.  I am creating combo chart with the Fiscal_Days as dimension.  Using the below as an example, I am trying to create a Plan by day estimate, but i can not get the calculation with Plan in it to show except on day 20 where it is loaded.

My last failed attempt is : (sum({\$<{Fiscal_Days=,Period={'Jan'}>}Plan))/max(Fiscal_Days)

This only appears on Day 20.

For this example, I would like to see the daily plan of \$1000 in the graph referencing the above formula.

Any thoughts??

 Period Year Fiscal_Days Sales Plan Jan 2018 1 1000 Jan 2018 2 1010 Jan 2018 3 1020 Jan 2018 4 1030 Jan 2018 5 1040 Jan 2018 6 1050 Jan 2018 7 1060 Jan 2018 8 1070 Jan 2018 9 1080 Jan 2018 10 1090 Jan 2018 11 1100 Jan 2018 12 1110 Jan 2018 13 1120 Jan 2018 14 1130 Jan 2018 15 1140 Jan 2018 16 1150 Jan 2018 17 1160 Jan 2018 18 1170 Jan 2018 19 1180 Jan 2018 20 1190 20000
• ###### Re: Set Analysis divide monthly value into daily value

What is the expected output you are looking for?

• ###### Re: Set Analysis divide monthly value into daily value

Maybe using TOTAL qualifier to ignore dimension values? like:

(sum(TOTAL <Year, Period> {\$<{Fiscal_Days=,Period={'Jan'}>}Plan))/max(Fiscal_Days)

• ###### Re: Set Analysis divide monthly value into daily value

I think this works, but i don't understand why.  Can you explain 'TOTAL' and why it needed to reference Year & Period?

• ###### Re: Set Analysis divide monthly value into daily value

I'm looking for something like this.  Used excel to show the math easier.  Basically, I want to show all the fiscal days as dimension and bar for Sales and line for calculation of plan by day.  This seems simple, but the coding is not straight forward.  I appreciate the help.

• ###### Re: Set Analysis divide monthly value into daily value

Then try what Ruben Marin gave above