Daily Budget Phasing

[#1]

Hi guys

Currently we only phase our budget monthly. But we look at our sales figures on a daily basis.

Is there a way I could load a monthly budget into Qlikview and it will divide the total monthly budget between all the working days in that specific month.

The result will be that I could compare daily sales vs daily budgets and also could see how we are doing Month to date.

Help will be appreciated.

Regards

[#2]

Hi

Has anyone got a solution for to how allocate a monthly budget to all the networkdays (working days) in a specific month?

Thanks

[Anonymous]

This may, or may not, help you depending on the complexity of what you are trying to achieve.

Assuming DateId is the PrimaryKey in your Calendar table

Sum(BudgetValue) / Day(MonthEnd(DateId))