Initial Balance of Cashflow

[#1]

Hi guys!

I'm trying to do something similar of the image:

I need to pick the total sum and compose the initial balance for the next period, because I just have values for the first month of the year.

Someone could help me?

Thanks!

[abeyphilip]

Hi Vitor,

Check the attached qvw. First value for balance - 1000 is hardcoded.

Regards,

Abey

[#3]

Hi Abey!

Almost it, but my problem is more complicated. I'll be more specific:

The chart I'm trying to use is a pivot table with five years, the description values come in a same field, so I tried to make it with set analysis, but it doesn't worked. I can't use the Column() function, new years and months will come and i can't handle the number of columns that the chart will bring because the user wants to see all the dates.

I appreciate your answer!

[abeyphilip]

Hi,

Can you post a sample qvw with test data?

regards,

abey

[#5]

Sure!

[abeyphilip · Accepted solution]

Hi Vitor,

Please see the attached file.

Created separate expressions for each of description values.

Regards,

Abey

[#7]

Hi Abey!

Thank you very much!  Exactly what I needed.

Regards,

Vitor

[#8]

Hello, I have the same problem with cash flow, but I can not see the solution because I use personal edition. Is there any other way as resolved?

Thank you, sebastian.-