Generating a planned value based on actual value for a period of time

[praveensp]

Hi,

I need some help in QlikView.

I have a PMO dashboard to create. I need to generate a series of values based on an actual value for a period of time.

For example, I have a project and i have a budget for that project. Also i have time duration for that project say 12 months.

Now I need to distribute this budget for 12 months. Just the way we use NORM.S.DIST in excel.

I am attaching an excel with calculation and steps to follow.

Let me know if this is possible. If YES, then how?

[Gysbert_Wassenaar]

Qlikview does have a normdist function. Perhaps this discussion can help you: https://community.qlik.com/t5/QlikView-Layout-Visualizations/Plotting-Normal-Dirstribution-bell-curv...