topic Re: Cash Flow Forecast Problem in QlikView

Cash Flow Forecast Problem

Gethyn — Mon, 15 Aug 2011 19:46:20 GMT

Hello,

I have a problem creating a formula to produce a cash flow forecast.

The fields I have are:

Opportunity

Estimated Close Date

Billing Frequency

PS Fees

Annual License Fee

I need to create a table, as shown below:

Which applies 50% of PS Fees, 1 month after Estimated Close Date.

Then the remainig 50% of PS Fees + 2 x Annual License Fee, 3 months after Estimated Close Date.

Opprotunity	Oct	Nov	Dec	Jan
Opportunity A	5000		10000
Opportunity B		5000		10000
Opportunity C		1500		15000
Total	5000	6500	10000	25000

Thanks in advance for your help,

Gethyn.

swuehl — Mon, 15 Aug 2011 20:50:23 GMT

Hi Gethyn,

please have a look at attached sample file.

I used a separate calendar for the Timeline, and quite straight forward if clause to calculate the fees.

Please have a look if this is applicable and appropriate to your requiremtents.

Regards,

Stefan

Gethyn — Tue, 16 Aug 2011 11:31:06 GMT

Hi Stefan,

Thanks for your speedy answer, it lokks as though it will work the way that I need it to. I will try it later and let you know.

Thanks,

Gethyn.